I think this has been the closest yet... but still no work. =(
  ----- Original Message -----
  From: Philip Arnold
  To: CF-Talk
  Sent: Tuesday, February 17, 2004 2:04 PM
  Subject: RE: query help...

  select top 1 *
  from estates
  where featured = 1
  Order by date_modified desc

  > From: Daniel Farmer [mailto:[EMAIL PROTECTED]
  >
  > This is my query...
  >
  > select * from estates where featured = 1 and
  >
  > [ I want to select the oldest date_modified field here ]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to