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. Link to comment https://forums.phpfreaks.com/topic/111919-comparing-for-the-existence-of-specific-data-from-two-tables/ 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 Link to comment https://forums.phpfreaks.com/topic/111919-comparing-for-the-existence-of-specific-data-from-two-tables/#findComment-574712 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.