> I would like to compare 2 tables in a database to determine which records
> are different!!! Any clues out there. Thanks in advance!
You didn't say which DBMS you are using. If you're using a DBMS which
supports INTERSECT (not MySQL), and assuming the two tables have the same
column names and types, you can do this:
(SELECT * FROM table1) INTERSECT (SELECT * FROM table2)
For MySQL INTERSECT support, monitor this doc:
http://www.mysql.com/doc/en/TODO_sometime.html
--Dave
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php