Join Types

INNER, LEFT, RIGHT, FULL, CROSS, and self joins

INNER, LEFT, RIGHT, FULL, CROSS, and self joins