Return to Answer

As I explained in this article, the CROSS JOIN is meant to generate a Cartesian Product.

For instance, assuming we have a one-to-many table relationship between a parent post and a child post_comment tables that look as follows:

Basically, you can think of the INNER JOIN as a filtered CROSS JOIN where only the matching records are kept in the final result set.

For more details about how INNER JOIN works, check out this article as well.

AThe CROSS JOIN is meant to generate a Cartesian Product.

For instance, assuming we have a one-to-many table relationship between a parent post and a child post_comment tables that look as follows:

Basically, you can think of the INNER JOIN as a filtered CROSS JOIN where only the matching records are kept in the final result set.

For more details about how INNER JOIN works, check out this article as well.

A Cartesian Product takes two sets A and B and generates all possible combinations of records from two given sets of data.

will generate all possible combinations of ranks and suites:

A Cartesian Product takes two sets A and B and generates all possible permutations of pair records from two given sets of data.

will generate all possible permutations of ranks and suites pairs: