Union all Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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
 
Back
Top