Lijoyx Posted July 15, 2008 Share Posted July 15, 2008 hi guys, i have 2 tables having same structure(fields) but different data . now i want to take the data from table2 which is different from the first table. i am looking for something like SELECT * FROM new_product EXCEPT SELECT * FROM product thanks in advance Link to comment https://forums.phpfreaks.com/topic/114801-solved-retrieve-only-different-data/ Share on other sites More sharing options...
fenway Posted July 15, 2008 Share Posted July 15, 2008 You can use NOT EXISTS, or a LEFT JOIN (my perference). Link to comment https://forums.phpfreaks.com/topic/114801-solved-retrieve-only-different-data/#findComment-590527 Share on other sites More sharing options...
Lijoyx Posted July 16, 2008 Author Share Posted July 16, 2008 Thank u very much Link to comment https://forums.phpfreaks.com/topic/114801-solved-retrieve-only-different-data/#findComment-591409 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.