When two tables are joined in the WHERE clause,it is not necessary to list both table names in the FROM clause if the result set will come from only one table.

Question

Quizplus · Accepted Answer

When joining two tables, regardless of where the join conditions are specified (in the FROM clause or the WHERE clause), both table names must be listed in the FROM clause to inform the database engine which tables are being joined.

When Two Tables Are Joined in the WHERE Clause,it Is