# 高分求解select查询问题~（这里高手多，求斑竹手下留情啊！！）

bbcboy 2003-07-27 10:13:02

A：
DM00 MC00
----------------
1001 苹果
1002 香蕉
1003 桃子
1004 西瓜
1005 橙子
1006 荔枝

DM00 SL01
---------------------
1001 50
1003 35

DM00 SL02
---------------------
1001 30
1002 56
1005 60

DM00 SL03
---------------------
1003 90
1004 50
1005 100
1006 76

MC00 SL01 SL02 SL03
-----------------------------------

================================

...全文
21 5 打赏 收藏 举报

5 条回复

chenbo2020 2003-07-29
• 打赏
• 举报

select a.mcoo,(select y1.slo1 from y1 where y1.dmoo=a.dmoo) as slo1,(select y2.slo2 from y2 where y2.dmoo=a.dmoo) as slo2,(select y3.slo3 from y3 where y3.dmoo=a.dmoo) as slo3 from a

bbcboy 2003-07-28
• 打赏
• 举报

(钱途渺茫的男人)，我在access查询中，只有显示个列，不能显示数据~
littlecpu 2003-07-27
• 打赏
• 举报

select
A.MC,
Y1.SL01,
Y2.SL02,
Y3.SL03
from A
left outter join Y1
on A.DM00 = Y1.DM00
left outter join Y2
on A.DM00 = Y2.DM00
left outter join Y3
on A.DM00 = Y3.DM00
chenbo2020 2003-07-27
• 打赏
• 举报

chenbo2020 2003-07-27
• 打赏
• 举报

select A.mcoo,B.slo1,C.slo2,D.slo3 from A as A,Y1 as B,Y2 as C,Y3 as D where A.dmoo=B.dmoo and A.dmoo=C.dmoo and A.dmoo=D.dmoo group by A.mcoo

535

2003-07-27 10:13