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 attribute values do not match.

Question

Quizplus · Accepted Answer

Joining tables using only the FROM clause can result in a Cartesian product, which is not always the correct or intended result. To correctly join tables, you need to use join conditions in the WHERE clause or use explicit join syntax in the FROM clause. Additionally, selecting rows with non-matching common attribute values is not always necessary or appropriate, depending on the type of join being used.

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