Need help comparing two tables

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

Guest

I have two tables that i need to find the fields that are not a perfect match
(perfect match meaning all fields must match in the tables). Tables and
fields shown below.

Items NewItems <--tables

Item# Item # <--fields
Cost Cost
Retail Retail

Show all Item#'s that the cost + retail dont match the other table linking
Item#'s.
 
Hi,


SELECT a.*
FROM a LEFT JOIN b
ON a.Cost = b.Cost AND a.Retail=b.Retail AND a.[Item#] = b.[item#]
WHERE b.cost IS NULL



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top