Skip to content

Case

SQLJoinMethod.left

A left (outer) join.
case left

Discussion

A left join is the result of performing an inner join, followed by adding additional result rows for every row of the left-side table which has no match in the right-side table with NULL values for any columns belonging to the right-side table.