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'"); 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! Link to comment https://forums.phpfreaks.com/topic/59096-solved-nested-statement/#findComment-293457 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.