Re: shorten SELECT query

2004-03-12 Thread Peter Brawley
iginal Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 12, 2004 9:31 AM Subject: shorten SELECT query Hi, I have multiple queries nested inside each other and was wondering, if there is a way to shorten this thing, e.g. run it within a single query

shorten SELECT query

2004-03-12 Thread stuff
Hi, I have multiple queries nested inside each other and was wondering, if there is a way to shorten this thing, e.g. run it within a single query with subqueries? I couldn't find anything in the subquery section of the docs or maybe I just don't know how to put it. At the moment my code fragment