1) Query Setup
SELECT Options
JOIN Builder (Optional)
INNER: only matched rows from both tables.
LEFT: all rows from base table + matched rows from joined table.
RIGHT/FULL: useful but not fully supported on some servers.
CROSS: all combinations, no ON key required.