Flipkart

Wednesday, July 15, 2009

Mysql : Get UnMatched Records from table1

SELECT * FROM table1 t1 WHERE t1.id NOT IN(select t2.t1_id FROM table2 t2)

No comments:

Post a Comment