suttercain Posted June 25, 2008 Share Posted June 25, 2008 Hi Everyone, I have two tables, both with the same column. TABLE A record1 record4 record9 record11 record13 TABLE B record1 record4 record13 I need to be able to output "TABLE B IS MISSING record1 and record 9" I use Php and MySQL but cannot figure out the correct MySQL statement to find the missing data based on another table. Please help. Thanks. Quote Link to comment Share on other sites More sharing options...
bluejay002 Posted June 26, 2008 Share Posted June 26, 2008 you may do: SELECT field_name, ... FROM table_a LEFT JOIN table_b ON table_a.pkey = table_b.fkey WHERE table_b.fkey IS NULL Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.