[AccessD] QyeryDef.Type dbQCompound

Hi Gustav

Here's the best I can do (from http://www.informit.com/ and Sams Teach Yourself SQL in 24 Hours):

"The compound query operators vary among database vendors. The ANSI standard includes the UNION, UNION ALL, EXCEPT, and
INTERSECT operators".

Which does seem to make sense.  After all a compound query is not merely a complex one, nor perhaps a query containing a
subquery.  The SAMS book also says "Compound queries enable you to combine the results of more than one query to return
a single set of data."  Exactly.

Whether this agrees with Access's use of the term, however, is another matter entirely!

John


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: 23 June 2013 08:52
To: accessd at databaseadvisors.com
Subject: [AccessD] QyeryDef.Type dbQCompound


Hi all

Could anyone please tell me what a compound query in Access is?

Of course, I've binged/googled and searched the on-line "help" but didn't find a single clue.

/gustav

-- 
AccessD mailing list
AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com