The Oracle (+) outer and cross join syntax is directly mapped to the DB2 database product.
Oracle(+)外连接和交叉连接语法被直接映射到DB 2数据库产品。
The first method in the following example shows a simple cross join.
下面示例中的第一个方法演示了一个简单的交叉联接。
The cross product returned by the unintentional cross join depicted above.
由上述无意生成的交叉联接返回的叉积。
A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join.
一个没有WHERE子句的交叉联接，会产生所关联表的笛卡尔乘积。
In a cross join, each row from one table is combined with each row from another table, resulting in what is called a cross product or a Cartesian product.
在交叉联接中，一个表中的每一行与另一个表中的每一行合并，导致生成叉积或卡迪尔积。
This type of join is called a CROSS join.
这种类型的连接称作交叉连接。
Note: CROSS JOIN may generate too many rows.
注意：交叉连接可能会生成太多行。
Note: CROSS JOIN may generate too many rows.
注意：交叉连接可能会生成太多行。
应用推荐