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

Published Date Author: , Posted May 16th, 2018 at 6:08:36pm

FROM tableOne t1
LEFT JOIN tableTwo t2 ON =

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.

No comments as yet.

Leave Your Comment  Leave a comment

All fields marked with "*" are required.