a cross join that does not have a where clause produces the cartesian product of the tables involved in the join.
一个没有where子句的交叉联接,会产生所关联表的笛卡尔乘积。
the cross product returned by the unintentional cross join depicted above.
由上述无意生成的交叉联接返回的叉积。
if you need more records, this insert statement can be repeated as many times as needed. you may also use a cross join to get more records per statement, like this
如果您需要更多记录,就可以根据需要多次重复执行这条insert语句。
the oracle (+) outer and cross join syntax is directly mapped to the db2 database product.
oracle (+)外连接和交叉连接语法被直接映射到db2数据库产品。
note: cross join may generate too many rows.
注意:交叉连接可能会生成太多行。