corza9090 Posted December 29, 2009 Share Posted December 29, 2009 Hello, I have two MYSQL tables that I need to compare. I basically need to find what asset numbers are missing from table two using the asset numbers from table one. Any help would be greatly appreciated. Corey Link to comment https://forums.phpfreaks.com/topic/186543-php-mysql-data-comparision/ Share on other sites More sharing options...
premiso Posted December 29, 2009 Share Posted December 29, 2009 SELECT asset_num FROM table_one WHERE asset_num NOT IN(SELECT asset_num FROM table_two) Should get you the desired results. Link to comment https://forums.phpfreaks.com/topic/186543-php-mysql-data-comparision/#findComment-985194 Share on other sites More sharing options...
corza9090 Posted December 29, 2009 Author Share Posted December 29, 2009 Thanks premiso! Link to comment https://forums.phpfreaks.com/topic/186543-php-mysql-data-comparision/#findComment-985198 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.