Combine 2 queries 1

[JCAA]

I currently have 2 queries that I need to combine one of the queries contain all the sale domestically and 1 contain all the international sale. They all include the same part numbers. I need to get all the line items in these 2 queries for my new query but my relationship choices limit me to unique items or all of the items in one or the other table. How do I get all the records from BOTH tables.

Thanks!!!

 

[Golom]

Without sample SQL its hard to say but you might try a UNION query
[tt]
(Select for DOMESTIC Sales)

UNION

(Select for INTERNATIONAL Sales)
[/tt]

 

[JCAA]

Thanks Golom! Got it with your help again! You are so helpful! Thanks

SELECT *
FROM [170E - Report of Forecast (Forecast Accuracy Dom)]

UNION SELECT *
FROM
[170E - Report of Forecast (Forecast Accuracy Intl)];