Concatenate Query Results

**Rawb** · 01-18-2011, 10:59 AM

Hey all!

Is there a way to get the results of a query and then stick them in with the results of another query using only SQL?

For example, I have the following query:

Code:

SELECT [PartID], [PartDesc] FROM PartMasterOTHER

And this Query:

Code:

SELECT [PartID], [PartDesc] FROM PartMasterGLASS

Now let's say that Query A (PartMasterOTHER) returns this:

Code:

PartID|PartDesc
T101|Terminator!
 T800|Sneeky Terminator!
 T9000|Liquid Terminator!
 TX|HAWT Terminator!

And Query B (PartMasterGLASS) returns this:

Code:

PartID|PartDesc
 001|3mm Clear Glass
   002|4mm Clear Glass
   003|5mm Clear Glass

How can I get the result:

Code:

PartID|PartDesc
 001|3mm Clear Glass
   002|4mm Clear Glass
   003|5mm Clear Glass
T101|Terminator!
 T800|Sneeky Terminator!
 T9000|Liquid Terminator!
 TX|HAWT Terminator!

Note that I'm NOT looking for the Cartesian product.

**RuralGuy** · 01-18-2011, 11:05 AM

A UNION Query will do as you asked.

**Rawb** · 01-18-2011, 01:01 PM

Unacceptable!

The solution must be moar harder!

>.<

**RuralGuy** · 01-18-2011, 05:17 PM

Okay, you *must* create the UNION Query with your eyes closed.

**RuralGuy** · 01-18-2011, 05:26 PM

A UNION Query is also Read Only if that make a difference.

**Rawb** · 01-19-2011, 07:08 AM

Having a Read-only Query is Fine. I only need it for a selection list Combo Box.

**RuralGuy** · 01-19-2011, 07:50 AM

Great! Is this thread ready for you to use the Thread Tools and mark as Solved?

Concatenate Query Results

Thread Tools

Concatenate Query Results

Similar Threads

Form to show query results and generate reports of these results.

Using a query to concatenate data

concatenate

Query results in subform

Query results order

Posting Permissions