Cartesian product of two sets of records A and B returns a set C such that C contains all ordered pairs (a, b) where a belongs to A and b belongs to B.

This definition can be easily generalized to the case of several sets.

Main idea behind cartesian product (or cartesian join, or cross join) is that it returns all possible combinations of rows from all tables specified in the query.

Login in to like

Login in to comment