Hello

I am trying to generate a list of monthly files backed up. I come up with
the select statement below which seems to be taking it's time (not sure if
it's legal). Does anyone know of a better way generate a summary of the
total no. of files backed up


TIA


Toni

select count(contents.file_name), count(volumes.volume_name) from
contents,volumes where volumes.volume_name=contents.volume_name and
volumes.last_write_date = '2002-01-04 00:00'