G Guest Dec 8, 2004 #1 Is there a query option to compare data differences between 2 tables with the same structure?
M Michel Walsh Dec 8, 2004 #2 Hi, Such as finding unmatched record? The wizard allows you to use just one field, but you can "add" more fields: SELECT a.* FROM a LEFT JOIN b ON a.f1=b.f1 AND a.f2=b.f2 AND a.f3=b.f3 AND a.f4=b.f4 WHERE b.f1 IS NULL Hoping it may help, Vanderghast, Access MVP
Hi, Such as finding unmatched record? The wizard allows you to use just one field, but you can "add" more fields: SELECT a.* FROM a LEFT JOIN b ON a.f1=b.f1 AND a.f2=b.f2 AND a.f3=b.f3 AND a.f4=b.f4 WHERE b.f1 IS NULL Hoping it may help, Vanderghast, Access MVP
