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!
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!