List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:November 25 2003 8:22am
Subject:Re: help needed!
View as plain text  
Hi,

> I need to add a new auto field to my db, but I need to make sure the
records are listed in order of one of the other fields first which is a date
field.
>
> Any ideas how I do this would be greatly appreciated!

"listing records" is in no particular order, unless you ask for an order.

SELECT ... column names ...
FROM ... table name(s) ...
WHERE ... where clause ...
ORDER BY MyDateColumn

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

Thread
help needed!Dominic Hayhoe25 Nov
  • Re: help needed!Martijn Tonies25 Nov
Re: help needed!Martijn Tonies25 Nov