2 queries in one?

2002-01-02 Thread Chris Boget
I've looked through the docs and I couldn't find out how to do this. If you can point me to the right place in the documentation so I can read how, that would be great. If you could give me a little sample query to start from, that would be great as well. I've 2 columns in a table. Status and

RE: 2 queries in one?

2002-01-02 Thread Jonathan Hilgeman
PROTECTED]] Sent: Wednesday, January 02, 2002 7:11 AM To: [EMAIL PROTECTED] Subject: 2 queries in one? I've looked through the docs and I couldn't find out how to do this. If you can point me to the right place in the documentation so I can read how, that would be great. If you could give me

RE: 2 queries in one?

2002-01-02 Thread Christian Pfeiffer
Should be something like Select Status, Date from Table where Status closed or Date now() - 14 (This is from memory so please dont rely on the syntax ;-) HTH, Chris -- Christian Pfeiffer Smart-Link Gesellschaft für EDV-Systemlösungen mbH Herforder Str. 5-7 www.smart-link.de