Question

Define a query that uses the Natural Join command to join three tables to produce useful information.

Answer 1

Answer:

SELECT column_1, column_2, ... column_n

FROM table_name_1

JOIN table_name_2 ON table_name_1.primaryColumn = table_name_2.foreignKeyColumn

AND table_name_3 ON table_name_1.primaryColumn = table_name_3.foreignKeyColumn

Explanation:

The SQL or structured query language statement returns information from the three tables in the database with the 'select' and 'join' clause in the statement. There are several types of join but the default is the inner join. Other types of join are; outer, left and right join.