This type of join is called a CROSS join.

这种类型的连接称作交叉连接。

youdao

Note: CROSS JOIN may generate too many rows.

注意：交叉连接可能会生成太多行。

youdao

The first method in the following example shows a simple cross join.

下面示例中的第一个方法演示了一个简单的交叉联接。

youdao

Labour, who came second in the mayoral vote, refused to join the cross-party cabinet.

BBC: Bristol City Council cabinet final members announced

But there is something about a small town that has never gone a single day, in almost 150 years, without a passenger train pulling in and pausing to see if anyone would like to step out onto the streets of Garden City, or if anyone from Garden City would like to climb aboard and join the other cross-continental travelers...

CNN: A Kansas town tries to keep the train coming through

In the face of present and growing missile threats, it is imperative that sensible members of the Democratic caucus do what they have done in droves on Gitmo: Ignore their leadership and cross the aisle, this time to join Republicans in defending America, before it's too late.

CENTERFORSECURITYPOLICY: Missile defense misjudgment