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

The committee has suggested that it should only be optional for a two year transitional period, becoming compulsory thereafter for large cross-border companies, with small businesses being forced to join a common system after a further five years.

BBC: Corporate tax debate