Junior — Senior
Complete overview of all SQL JOIN options using two tables as an example
livecode
Task condition
Given two tables — T1 and T2. It is necessary to perform their join using each of the standard JOIN types (INNER, LEFT, RIGHT, FULL, CROSS, etc.) and specify which rows will be present in the result of each join.