[求助]两个表之间的联查
Match表:有字段 matchId, hostTeamId, guestTeamId, matchResult, matchTime;
Team表:有字段 teamId, teamName;
查处2006-6-1到2006-7-1之间的所有比赛, 并根据时间排序, 格式为 曼联 2:1 切尔西 2006-6-1
我这里写了一个sql查询但是不对,希望大家帮我该一下:
select Team.Name, Match.match.matchResult, Team2.Name, Match.matchTime
from Match inner join
Team Team2 on Match.hostTeamId = Team.teamId and Match.guestTeamId = Team2.teamId
where (Match.matchTime > '2007-6-1 ') and (Match.matchTime < '2007-7-1 ')
order by Match.matchTime
thx!
[解决办法]
selet matchid, (select teamName from team where team.id = m.hostteamid) as hostteamname, (select teamName from team where team.id = m.guestteamid) as guestteamname , matchresult, matchtime from match m
where matchTime > '2007-6-1 '
and Match.matchTime < '2007-7-1 '
