Which query will find rows in a table that have no counterpart in another table?

Which query will find rows in a table that have no counterpart in another table?FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.idWHERE right_tbl.id IS NULL;FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2;FROM employee t1 INNER JOIN info t2 WHERE t1.name=t2.name;Reference: https://stackoverflow.com/questions/18000564/mysql-query-for-finding-rows-that-are-in-onetable-but-not-another

Question:

Which query will find rows in a table that have no counterpart in another table?

Options:

SELECT *FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id=! table2.id;

SELECT left_tbl.*

SELECT t1.name, t2.name2

SELECT t1.name, t2.name2

Correct Answer

The Correct Answer for this Question is

SELECT left_tbl.*