Posted by masri999 on 11/02/06 22:07

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:
> 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.

[Back to original message]