How to write this query??

[Inandjo Taurel]

hi all,
i have a table trans with this structure:

today(date) | heure1(time) | amount(double) | client(varchar 30)

Now i need to write a query that would take the start date and time, end date and time, and return all the records between the two.

So for example, the query should return all records between 01/01/2002 at 17:00 and 01/30/2002 at 08:00.
How can i get that query in one query??

SQL SQL


_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php