Question

Which query retrieves all records from TableA that have no corresponding records in TableB?

A SELECT * FROM TableA INNER JOIN TableB ON TableA.id = TableB.id;
B SELECT * FROM TableA LEFT JOIN TableB ON TableA.id = TableB.id WHERE TableB.id IS NULL;
C SELECT * FROM TableA RIGHT JOIN TableB ON TableA.id = TableB.id WHERE TableA.id IS NULL;
D SELECT * FROM TableA FULL OUTER JOIN TableB ON TableA.id = TableB.id;
E SELECT * FROM TableA WHERE id NOT IN (SELECT id FROM TableB);
Practice Next

Hey! Ask a query