In order to join two tables, we will utilize the basic structure of a
SELECT statement; but, we must add a few qualifiers.
When we join two tables, we add a
WHERE clause that qualifies that the common columns between the tables are equivalent. The following is the syntax tree for an ANSI-compliant join:
SELECT column1, column2, ... FROM table1, table2 WHERE table1.common_column = table2.common_column;
While the join syntax is similar in many ways to a typical
select statement, we notice some differences.
FROMclause, separated by commas