Hi Assume I have two tables, A and B, and both share a key field (for the sake of argument, lets call it key_id). Is there a way to determine for which values of key_id in A there is no corresponding row in B?
e.g I might have Table A: key_id , value 1,1 2,1 3,3 4,4 and Table B key_id, othervalue 1,4 3,4 I basically want to know if there's a query that return's 2 and 4 as key_id's in A but missing from B? Any sql gurus out there? Cheers Tim -- Tim Wood Predictive Technologies ph +61 3 8344 0395 (BH) +61 413 845 317 ---- Everyone talks about apathy, but no one does anything about it. --------------------------------------------------------------------- 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
