Arthur Fuller
fuller.artful at gmail.com
Sun Jun 23 10:42:15 CDT 2013
I found this on the MSDN site: Name Value Description dbQAction 240 Action query dbQAppend 64 Append query dbQCompound 160 Compound query dbQCrosstab 16 Crosstab query dbQDDL 96 Data-definition language (DDL) query dbQDelete 32 Delete query dbQMakeTable 80 Make-table query dbQProcedure 224 SQL procedure that executes a stored procedure dbQSelect 0 Select query dbQSetOperation 128 Set operation query dbQSPTBulk 144 Bulk operation query dbQSQLPassThrough 112 SQL pass-through query dbQUpdate 48 Update query I Googled compound query and this example came up: SELECT EMP_ID FROM EMPLOYEE_TBL UNION SELECT EMP_ID FROM EMPLOYEE_PAY_TBL; The ANSI standard for compound queries includes UNION, UNION ALL, EXCEPT and INTERSECT. Support for these keywords depends upon the back end. Arthur