Union help

[Golfinray]

I need to put four tables together in a union query into one table: 07-09 A,
07-09 B, 07-09 C and 07-09 D. I'm not quite familier with the syntax of
unions. Please help. Thanks a bunch!!!

 

[KARL DEWEY]

If they all have the same fields then this will do it --
SELECT *
FROM [07-09 A]
UNION ALL SELECT *
FROM [07-09 B]
UNION ALL SELECT *
FROM [07-09 C]
UNION ALL SELECT *
FROM [07-09 D];