Tag Archives: mysql

How to select rows with no matching entry in another table

Here’s a little tip that I found very useful for a recent project that I was doing. When using MySql, some time you may want to query the rows of a table that don’t match another table. Well Ive got the perfect solution for you! SELECT t1.ID FROM Table1 t1 LEFT JOIN Table2 t2 ON t1.ID = t2.ID WHERE t2.ID IS NULL Just change t1 and t2 to mach you table names!