dear all, i have a problem to compare data inside two tables. i have two tables let say: "Master" and "Pick". For example the content of these two tables are:
Table "Master" Table "Pick" a a b b c c d d e f g my goal is to know any data that missing in table "pick" comparing to table "master". The answer should be "e, f, and g". Would you help me to show me the query? thank you so much .. --------------------------------------------------------------------- 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
