Two query to merge together making one file

[Don White]

I have two queries, not tables

One has the following data:

fac Grp
001 001
111 111
222 222

The other query has following data:

fac grp
001 001
444 444
555 555

I need to make one query with all 6 records in the output of the created query. The second query has new record that are 444, and 555. The data will be:

fac grp
001 001
001 001
111 111
222 222
444 444
555 555

I want to merge the two query files togther, or append one to the other. both queries are the same format.

Help!!!!!!

 

[Newman]

You need to do a «Union Query» in SQL. Make a search with «Union Query» for more information.