Is it possible to create a query of queries without using UNION

[June7]

Really should not use spaces nor punctuation (underscore only exception) in naming convention. Better would be SupplierNo3Name or SupplierNo3_Name.

 

[Oscar42]

Really should not use spaces nor punctuation (underscore only exception) in naming convention. Better would be SupplierNo3Name or SupplierNo3_Name.

Yep, have just changed them all. I will have to use spaces in the Alias's though as these are what the user eventually sees in the 3rd party applications so want it to be nice readable.