select B.TeamName, A.Time, C.TeamName from 比赛A表 as A left join 基本资料表 as B on A.TeamAID = B.TeamID left join 基本资料表 as C on A.TeamBID = C.TeamID
select (select teamname from b where teanaid=a.teamaid) 团队A方名称,a.time,(select teamname from b where teanaid=a.teambid) 团队B方名称 from a或:select b.teamname 团队A方名称,a.time,c.teamname 团队B方名称 from a join b on a.teanaid=b.teamaid join b as c on a.teanaid=c.teambid
left join 基本资料表 as B on A.TeamAID = B.TeamID
left join 基本资料表 as C on A.TeamBID = C.TeamID