如何在访问中使用交叉连接? [英] How to use cross join in access?

问题描述

使用 MS - ACCESS 2003

Using MS - ACCESS 2003

表格

S.No   Details

1      name
2      address
3      email
4      phone
5      fax

等等...,

我想结合 s.no 的所有细节.喜欢

I want to combine all the details for the s.no’s. Like

预期输出

S.No Details

1    name
     address 
     email
     Phone
     Fax
2    address
     name
     email
     phone
     fax
3    email 
     name
     address
     phone
     fax
4    phone
     name
     address
     email
     fax
5    fax
     name
     address 
     email
     Phone

以此类推，

Access 2003 中不接受交叉连接?任何其他解决方案.

Cross join is not accepting in access 2003? Any other solution for this.

需要查询帮助.

推荐答案

我不确定要完成什么，但是完整笛卡尔积(交叉连接)的语法是 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
....

希望这会有所帮助.

这篇关于如何在访问中使用交叉连接?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！