Compare Records from Seperate Tables ? (Find uncommon)
I have a table called Inventory:
Uniquely Identified by ItemCode (all records in this table are imporated from another DB called MAS)
I have a table called Products:
Where ModelNo has the relationship with ItemCode (as a unique identifier)
I have some records that are listed in Inventory only, and do not show in Products
How do I construct a script to find which ones are missing ?
How do I pick up the "Model3"
I wrote a script that loops through all the records in the Inventory Table and if they = ModelNo from Products, Do nothing, Else, it writes that ItemCode to a email.
It worked for 1 Model Number but still a handful that it did not detect.