Merging two queries of data using outer joins

[scorpio]

-I have two tables of data where I am trying to compare the difference in quantity and savings from month to month.


-Both tables include item #, supplier, qty, cost.
-Some of the item # and supplier fields are blank in either table, the data is different in lengths and is not consistent throughout.
-Also some of the item #s are duplicated within a table but I need to include those because the supplier, qty and cost may be different.

-I want not only data from both TableA and TableB when the key fields match, but also all the data from TableA and from TableB where they don't match. And a flag or indicator that tells me how they match.

Below is an example of the results I would like to see:

Table A Table B Flag

Data table A only
Data table A only
Data Table A only
Data Data table A & B
Data Data Table A & B
Data Data Table A & B
Data table b only
Data table b only
Data table b only

[June7]

This might call for a UNION query.

Create a UNION then join table B to the UNION with join type "Include all records from the {union query} and only those from Table B that match.