A. Combines rows from two or more tables based on a related column
B. Retrieves all rows from both tables, regardless of a match
C. Performs a join operation with a condition
D. Creates a Cartesian product of two tables

Solution

D. Creates a Cartesian product of two tables