有两张表
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

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

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

那该怎么写呢!

你这个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