I have written a SQL query in ACCESS that compares the differences in two tables and then returns all the rows of data that do not match between the tables.
However I need to exclude records from TestA that are not in TestB table. If anyone has something that will help I would appreciate it.
SELECT tmp.COL1, tmp.COL2, tmp.COL3, tmp.COL4
FROM [SELECT TestA.COL1,TestA.COL2, TestA.COL3, TestA.COL4
SELECT TestB.COL1,TestB.COL2,TestB.COL3, TestB.COL4
]. AS tmp
GROUP BY tmp.COL1, tmp.COL2, tmp.COL3, tmp.COL4
ORDER BY tmp.COL2, tmp.COL3;