Hi, I need to make an Access query that will outer join four separate tables, for example:
tblItemsA
UPC
Description
Dept
Aisle
Price
LastSold
tblItemsB
UPC
Description
Dept
Aisle
Price
LastSold
tblItemsC
UPC
Description
Dept
Aisle
Price
LastSold
tblItemsD
UPC
Description
Dept
Aisle
Price
LastSold
They should be joined on UPC, some UPCs are in all four table and some are only in one. I need a common list so that I can report on the price field.
Thanks in advance.
tblItemsA
UPC
Description
Dept
Aisle
Price
LastSold
tblItemsB
UPC
Description
Dept
Aisle
Price
LastSold
tblItemsC
UPC
Description
Dept
Aisle
Price
LastSold
tblItemsD
UPC
Description
Dept
Aisle
Price
LastSold
They should be joined on UPC, some UPCs are in all four table and some are only in one. I need a common list so that I can report on the price field.
Thanks in advance.