|
Posted by Freddie on 11/02/06 19:22
Hello everyone:
i am trying to compare a MAX(DATE) from one table that would be greater
than a date in another.
first_table
compname MYDATE
abc comp 2006-09-26 09:19:43.250
123inc 2006-10-20 01:3:00.250
SELECT MAX(MYDATE) FROM first_table
log_table
logdate
2006-01-15 05:12:41.250
I would like to get the MAX(MYDATE) which is greater than the logdate.
thx
f.
Navigation:
[Reply to this message]
|