Union help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Golfinray - 28 Apr 2008 15:29 GMT

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!!!

Reply to this Message

KARL DEWEY - 28 Apr 2008 15:49 GMT

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];

Signature

KARL DEWEY
Build a little - Test a little

> 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!!!

Reply to this Message