17.1: JOIN & ON Clauses ​ JOIN: Join tables together to connect multiple fields into 1 query. ON: Linking the primary and foreign key Linking formula: FROM table1 + JOIN table2 ON table1.primarykey = table2.foreignkey