Toni
> 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 ..
Assuming field m in master and p in pick...
SELECT m from master
LEFT JOIN pick on master.m=pick p
WHERE pick.p IS NULL
PB
---------------------------------------------------------------------
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
