Keyword JOIN is meant for selection of data from two tables and presentation of such data in single table. To put it in crude terms, keyword JOIN helps to transform two tables into one. There are different use cases of JOIN: INNER, OUTER, CROSS The most often used type of joining is INNER JOIN INNER JOIN function returns chained rows, which meet the condition, in a single table. Press "Check my work" to continue