我不确定要完成什么，但是完整笛卡尔积(交叉连接)的语法是 select * from table1,table2

I'm not sure about what do want to accomplish, but the syntax for a full cartesian product(cross join) is select * from table1, table2

如果您不想跨越所有内容而只想跨越某些列，例如

If you don't want to cross everything but only some columns, something like

SELECT *
FROM (select id from details) b, (select detail from details) c
;

应该可以:

id  detail
1   name
2   name
3   name
4   name
5   name
1   email
2   email
....

希望这会有所帮助.