JOIN clauses

Supported JOIN types include: INNER, UNION, LEFT, RIGHT, FULL, NATURAL, and CROSS.

Tip: The database management system (DBMS) on which the query is performed may involve querying limitations.