SQL Join keywords
F
FULL JOIN
The SQL FULL JOIN (FULL OUTER JOIN) returns all rows from both tables, matching rows where possible and filling missing values with NULLs.
I
INNER JOIN
The SQL INNER JOIN returns only rows that have matching values in both tables.
J
JOIN
The SQL JOIN clause combines rows from two or more tables based on a related column.
L
LEFT JOIN
The SQL LEFT JOIN returns all rows from the left table and matching rows from the right table.
R
RIGHT JOIN
The SQL RIGHT JOIN returns all rows from the right table and matching rows from the left table.