combining DBs for universal list

R

Ryan S

There's six different stores w/ all unique part numbers in their inventory
system. I'm building Oklahoma City's information system as the master
(primary key) key for a universal part numbering system. I want to know if
the other systems have any part #s that OKC doesn't have. Any help is
appreciated.
 
J

John Spencer (MVP)

If the data is in two different tables then try using the Unmatched query wizard
to build your query. Basic idea is

SELECT A.*
FROM [YourOKTable] as OKC
RIGHT JOIN OtherCityTable as A
ON OKC.[PartNumber] = A.[PartNumber]
WHERE OKC.[PartNumber] is Null

This will return the part numbers and other data in the Othercity's table that
is not in the Oklahoma City table.

Repeat for each of the other cities.
 
Top