> Date: Mon, 7 Aug 2006 13:36:11 +0100 > From: "Chris Moore" <[EMAIL PROTECTED]> > Subject: Multiple query > To: "DelphiDB List" <[email protected]> > Message-ID: > <[EMAIL PROTECTED]> > Content-Type: text/plain; charset="us-ascii" > > Hi Group > > In any RDBMS it is possible to build a query, and then use > that query as the basis of another query. > > Very simple example: > open_d = (Select * from openday where opendate > 21/06/06) > week_d = (Select * from open_d where day = 'mon') > Yes, Oracle supports that type of construct. Views are another way. FWIW - I wouldn't run mission critical on MS Sql.
Mick _______________________________________________ Delphi-DB mailing list [email protected] http://www.elists.org/mailman/listinfo/delphi-db
