I need help with a query

[Dave]

I have two tables with the same fields and I want to run a query that stacks
the information on top of the other. Sort of like an append, but I do not
want to create a table. Ex:

T1 has ID, EmplID
T2 has ID, EmplID

T1 1 111111
T1 3 333333


T2 2 222222
T2 4 444444

Result would be:

ID EmplID
1 111111
2 222222
3 333333
4 444444

Is this possbile and if so how do I do it?

Thanks

Dave

 

[Guest]

Use a union query to join both tables
Select Id, EmpId From Table1 Union
Select Id, EmpId From Table2

 

[Graham R Seach]

Dave,

A union query will work in this case.

SELECT ID, EmpID FROM
(SELECT ID, EmpID FROM T1
UNION
(SELECT ID, EmpID FROM T2))
ORDER BY ID

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Dave]

Thank you very much - it shouldn't be this easy

Dave