Union all Query

[Guest]

Good Day,

Can I perform a Union All Query on more than one query ? I have three
separate queries I would like to Union/Merge.. is this possible?

Thanks,

Brook

 

[John Vinson]

Good Day,

Can I perform a Union All Query on more than one query ? I have three
separate queries I would like to Union/Merge.. is this possible?

Thanks,

Brook

Sure, many queries (within limits, you'll eventually get a Query Too
Complex error):

SELECT this, that, theother FROM Query1
UNION ALL
SELECT something, somethingelse, whatever FROM Query2
UNION ALL
SELECT a, b, c FROM Query3;

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps