Programming Forums - View Single Post - comparing same table from 2 different .mdb files

Rory · Jun 28th, 2005, 5:46 PM

Well in MS SQL, this should return only the rows that do not occur in both tables (i.e. differences) "SELECT * FROM table1 FULL OUTER CROSS JOIN table2". Whether it'll work with Jet is another matter!

Jun 28th, 2005, 5:46 PM	#2
Rory Expert Programmer Join Date: Jan 2005 Location: London Posts: 542 Rep Power: 4	Well in MS SQL, this should return only the rows that do not occur in both tables (i.e. differences) "SELECT * FROM table1 FULL OUTER CROSS JOIN table2". Whether it'll work with Jet is another matter!