How To Select Rows in MySQL with No Matching Entry in Another Table
erics, May 16th, 2018 SELECT t1.id FROM tableOne t1 LEFT JOIN tableTwo t2 ON t1.id = t2.id WHERE t2.id IS NULL The “WHERE t2.id IS NULL clause” restricts the results to only those rows where the id returned from tableTwo is null. tableTwo.id will be NULL for all records from tableOne where the id is not found in tableTwo.
Categories: How-To's, Technology howto, Join, Left Join, mysql, Query, Row, Rows, select, SQL, Table, tips, Where
| 
No comments
