Power Query vs SQL Joins

The following table compares Power Query Join Kinds with their equivalent SQL Join types. Each join kind is explained with a visual icon and SQL analogy.

Join Kind	Description	SQL Equivalent
Left Outer	Returns all rows from the left table and matching rows from the right. Non-matching right rows are set to null.	`LEFT JOIN`
Right Outer	Returns all rows from the right table and matching rows from the left. Non-matching left rows are set to null.	`RIGHT JOIN`
Full Outer	Returns all rows from both tables. Where there’s no match, nulls are inserted.	`FULL OUTER JOIN`
Inner	Returns only rows with matching values in both tables.	`INNER JOIN`
Left Anti	Returns rows from the left table that have no match in the right table.	`LEFT JOIN ... WHERE right.id IS NULL`
Right Anti	Returns rows from the right table that have no match in the left table.	`RIGHT JOIN ... WHERE left.id IS NULL`
Full Outer Anti	Returns all rows from both tables where there’s no matches	`FULL OUTER JOIN ... WHERE left.id IS NULL AND right.id IS NULL`