> Date: Mon, 7 Aug 2006 13:36:11 +0100 > From: "Chris Moore" <[EMAIL PROTECTED]> > Subject: Multiple query > To: "DelphiDB List" <delphi-db@elists.org> > 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 Delphi-DB@elists.org http://www.elists.org/mailman/listinfo/delphi-db
