这个查询该怎么写?

等待冰柠檬发布于 2009-11-06 18:36， 650 次点击

有两张表
1张表 QiuDui[QuiDui_BianHao、QuiDui_MingCheng、QuiDui_XiaoZu]
1张表 SaiCheng[SaiCheng_BianHao、SaiCheng_QiuDuiA、SaiCheng_QiuDuiB]

想显示两只球队的对阵
select SaiCheng_BianHao as 场次,QuiDui_MingCheng as 球队1,QuiDui_MingCheng as 球队2 from SaiCheng,QiuDui where QuiDui_BianHao=SaiCheng_QiuDuiA and QuiDui_BianHao=SaiCheng_QiuDuiB

但是这样查询一条记录都不显示！

3 回复

gdy03492009-11-06 23:33

你写的也太乱了吧，这样写QuiDui_BianHao=SaiCheng_QiuDuiA and QuiDui_BianHao=SaiCheng_QiuDuiB
怎么可能有结果

等待冰柠檬2009-11-07 09:33

那该怎么写呢!

师妃暄2009-11-09 11:45

你这个where条件相当于 (1=1 and 1=2 )这当然查不出记录
这样:
select a.SaiCHeng_BH as 场次,b.QiuDui_Name as 球队1,c.QiuDui_Name as 球队2
from SaiCheng a left join QiuDui b on a.SaiCHeng_QiuDuiA=b.QiuDui_BH
left join QiuDui c on a.SaiCHeng_QiuDuiB=c.QiuDui_BH