I am trying to compare two tables and get a list of all the data that does not match. How can I compare all the fields from two tables with one SQL statement? I've been using the Find Unmatched Query Wizard, but it will only let me compare one field at a time. I want to list all the ID numbers that have differing info in any field from two tables.
Jac --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
