SQL Puzzle

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.