Re: SQL query problem
| From: | Mike Quinn | Date: | Mon, 29 Sep 2003 05:38:08 +0000 |
| Subject: | Re: SQL query problem | ||
| References: | 1 2 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-21603@lists.php.net to get a copy of this message | ||
Hi George,
Just at a quick glance it might be to do with the Date(); Remove that
clause and see what happens. I could be wrong.
Rgds,
Michael
"George Pitcher" <george.pitcher@ingenta.com> escribió en el mensaje
news:AMEPJAJDOFCDLPGFDOIFMEODCHAA.george.pitcher@ingenta.com...
> 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