SQL query problem
| From: | George Pitcher | Date: | Mon, 29 Sep 2003 11:32:17 +0000 |
| Subject: | SQL query problem | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-21602@lists.php.net to get a copy of this message | ||
Hi,
I'm having a problem with the following query (ODBC on M$ Access):
select Pack.*, Transacts.*, Extracts.* from Pack, Transacts, Extracts where
(
Pack.End > date() and Pack.Term='Lent' and Transacts.Week=1 and
Transacts.Pack_ID=Pack.Pack_ID and Extracts.ID=Transacts.Extract_ID)
ORDER BY Pack.Term DESC, Transacts.Week ASC, Pack.Course_ref ASC
I get a 'no records' return.
Any suggestions for re-jigging the query.
Cheers
George in Oxford