Cross joins produce all possible combinations of rows from tables which are joining. If we have again table A and table B, and each table has 3 rows, cross joins will produce 3x3=9 rows.
Examples:
Pure natural join can produce also an cartesian product when the joining tables do not have identical named columns.
Example :
No comments:
Post a Comment