Hi All
I have a table where all worker logon and out every day:
table columns: record_id, worker, log_time, status, description
If a worker was absent there will be no record for the current day.
Now, I want to query this table to get a list of all days in month and in an
aditional field i would like to put worked/abscent ( depends if he was or
was not )
Is it possible in SQL ?
I thought about fuction with 'for' from 1 to 30 then subselect to check if
worker worked on a current day but its a complicated solution.
Does any body have idea for easier method ?
I can do it easily in php but i want to do as maximum as I can on the db
itself.