select * from estates where featured = 1 and date_modified=(select max(date_modified) from estates)


Nick Han

>>> [EMAIL PROTECTED] 02/17/04 10:14AM >>>
This is my query...

select * from estates where featured = 1 and

[ I want to select the oldest date_modified field here ]



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Daniel Farmer
Coldfusion Developer / Sales / Producer
613.284.1684
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to