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 Quote 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. Quote 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! Quote Link to comment https://forums.phpfreaks.com/topic/186543-php-mysql-data-comparision/#findComment-985198 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.