combining DBs for universal list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top