MAX(DATE) - help

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.Freddie ,
If I understand correctly ,

What you want all the dates in log_table having date less than
max(date) in first table

SELECT * FROM log_table WHERE log_date < (SELECT MAX(DATE) FROM
first_table)

M A Srinivas
Freddie wrote:

Quote:

Originally Posted by

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.