Combine Results of Two Queries

[Ganymede]

I have 2 queries with identical fields, but different data:

Field A

Name	Date	Invoice
A	1	50
B	2	51
C	3	52

Field B

Name	Date	Invoice
D	4	53
E	5	54
F	6	55

I want to combine both queries into a single query like so:

Name	Date	Invoice
A	1	50
B	2	51
C	3	52
D	4	53
E	5	54
F	6	55

There is no other way to do it. Although the fields are similar, the data is extracted from different sources. So is there any way to combine the results of both queries?

Thanks

[pbaldy]

Sure, a UNION query.

SELECT Field1, Field2, Field3
FROM FirstTable
UNION ALL
SELECT Field1, Field2, Field3
FROM SecondTable

[Ganymede]

That did it. Thank you.

[pbaldy]

No problem.