[AccessD] QyeryDef.Type dbQCompound

Hi John

I think this is just a common way of talking about a query that it is a little more than a straight select/update/append query. My feeling is, that an Access compound query is something quite special with its own icon.

/gustav 

>>> djkr at msn.com 23-06-13 13:55 >>>
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