Match the descriptions to these joins terms: INNER JOIN, LEFT JOIN, FULL OUTER JOIN, CROSS JOIN.

JoinsConcept relationships

Choose a match for every item. Use each answer once.

A left outer join preserves the left relation even when a match is absent.

A cross join produces a Cartesian product, with row count equal to the product of input counts.

An inner join discards rows that have no matching row on the other side.

A full outer join includes matches plus null-extended rows from either unmatched side.

Loading question…