SQL - Using Cross Joins

来源:互联网 发布:小米3qq健康 数据来源 编辑:程序博客网 时间:2024/04/30 03:05

A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join. The size of a Cartesian product result set is the number of rows in the first table multiplied by the number of rows in the second table.

However, if a WHERE clause is added, the cross join behaves as an inner join.

1 0
原创粉丝点击