eightFX Posted July 9, 2007 Share Posted July 9, 2007 Hello everyone, I am hoping I can get some help for the issue I am facing. I have two tables and need the data from table1 that is not in table2 and I do not want duplicates displayed. This is what I have so far that is not working: $item_CG = mysql_query("SELECT * FROM table1 WHERE item_no NOT IN (SELECT item_number FROM table2) AND item_type = 'CG'"); Quote Link to comment https://forums.phpfreaks.com/topic/59096-solved-nested-statement/ Share on other sites More sharing options...
eightFX Posted July 9, 2007 Author Share Posted July 9, 2007 Disregard. Issue has been solved. I forget to put in the code that to select the database. Therefore had no idea where to look. Got to love Mondays! Quote Link to comment https://forums.phpfreaks.com/topic/59096-solved-nested-statement/#findComment-293457 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.