To join tables,simply enumerate the tables in the FROM clause of the SELECT statement.The DBMS will create a Cartesian product of every table in the FROM clause.To get the correct results,you need to select the rows in which the common attributes do not match.

Question

Quizplus · Accepted Answer

To get the correct results while joining tables, you need to specify the join condition (common attributes) using the JOIN clause or the WHERE clause. Simply listing the tables in the FROM clause will lead to a Cartesian product, which is usually not what you want.

To Join Tables,simply Enumerate the Tables in the FROM Clause