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 Quote Link to comment 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). Quote Link to comment Share on other sites More sharing options...
Lijoyx Posted July 16, 2008 Author Share Posted July 16, 2008 Thank u very much Quote Link to comment 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.