这个查询该怎么写?
有两张表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
但是这样查询一条记录都不显示！
