Stuart McLachlan
stuart at lexacorp.com.pg
Sat Feb 1 16:04:00 CST 2003
That's neat. Is that "[.]." syntax documented anywhere? >> or wrap the select/union part as an > > in-line (sub)query using the strange "[ .. ]." syntax which I learned > > from Paul (look in the archives for subject: SQL in-line subquery): > > > > INSERT INTO Table12 > > (Field1, Field2) > > SELECT > > Field1, Field2 > > FROM > > [SELECT > > Field1, Field2 > > FROM > > Table1 > > UNION ALL > > SELECT > > Field1, Field2 > > FROM > > Table2;]. > > AS subQuery; > > > > UNION ALL will select all records from the two tables. > > Omit ALL if you wish distinct records only. > > The name subQuery can be nearly anything except reserved words. > > > > /gustav > > > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.