How To Select Rows in MySQL with No Matching Entry in Another Table

Author: , May 16th, 2018

SELECT FROM tableOne t1 LEFT JOIN tableTwo t2 ON = WHERE IS NULL The “WHERE IS NULL clause” restricts the results to only those rows where the id returned from tableTwo is null. will be NULL for all records from tableOne where the id is not found in tableTwo.