Union Query

[Mike]

What is a union query? Would that be the best possible way?

Thanks


Did you try creating a UNION query?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Gina Whipp]

ike,

A Union query takes data from two (or more) tables and/or queries and makes
it appear as if it is from one source, ie...

SELECT crCustomerID
FROM qryOnHoldCoils
UNION SELECT CustomerID
FROM qryOnHoldLifts;

These can *run* slowly so use them sparingly. For a more detailed
definition, see Access Help.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Douglas J. Steele]

It's also worth pointing out that UNION queries are always read-only.

 

[Gina Whipp]

Okie dokie... updating my Newsgroup Replies to reflect this information...
THANKS!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

A further point to consider is that if there can be no duplication of the
rows returned, or if any duplicate rows are specifically required to be
returned, a UNION ALL operation should be used rather than a UNION
operation,
the former being more efficient.

Ken Sheridan
Stafford, England

It's also worth pointing out that UNION queries are always read-only.

ike,

[quoted text clipped - 40 lines]

Thanks in advance.