dates

[Sandeep Murphy]

hi,

I need to extract all the records from a table where the date of the record
is later than the last time the user logged in...

my query reads like this...


select distinct mh.code,rubrica from multimedia_header mh, members_log ml
where mh.date > ml.date and member =43

can anyone pl tell me whats wrong with it??

TIA,
sands