Computer scienceFundamentalsSQL and DatabasesBasics SQLRetrieving Data

Types of JOINs

Theory

Multiple tables

Report a typo

Correctly rearrange the lines of the template with which you can join multiple tables.

Put the items in the correct order
ON table1.col_name_table1 = table2.col_name_table2
SELECT val1 [AS name1], ..., valN [AS nameN]
FROM table1
[type_of_join] JOIN table3
[type_of_join] JOIN  table2
ON table2.col_name_table2 = table3.col_name_table3;
___

Create a free account to access the full topic