Compare 2 Tables reaturn all records

[RJL1]

Hi,

I'm working on comparing 2 tables identical structure

Table A has 157 unique items
Table B has 102 unique items

Some of the items are in both tables. However there are items in A that do not exist in B and items in B that do not exist in A.

How can I get a list of all the items from both table A nd B that also shows the ones that match

Sample Output

ITEM (A)    DESCRIPTION (A)   ITEM (B)   DESCRIPTION (B)   

90887       BLUE WIDGETS      NULL       NULL
89443       RED WIDGETS8      89443      RED WIDGETS
NULL        NULL              56477      GREEN WIDGETS

Thanks in advance
RJL

 

[simian336]

Just do an outer join..

Select a.item, a.DESCRIPTION, b.ITEM, b.DESCRIPTION
from atable a
full outer join btable b
on a.item=b.item

Simi

 

[JonFer]

You want to use the "Full Outer Join" which will bring in all records from both tables.

John

http://www.interautomateconsulting.com