SELECT e.IpNamn as Arena, S_Match.Speltid, hasSerie.Division, hasGame.SpelOmgang AS Omg, hasGame.Speldatum as dat, hasGame.Matchnr, hasGame.Status, a.LagNamn AS Home, b.LagNamn AS Guest, hasGame.HemmaMal AS H, hasGame.BortaMal AS G, hasGame.Publik, hasGame.PeriodText, hasGame.Information, hasSerie.SerieID FROM hasGame inner join hasSerie on hasSerie.SeasonId = hasGame.SeasonId and hasSerie.SerieId = hasGame.SerieId inner join hasPlace e on e.IpId = hasGame.IpId left outer join S_Match on S_Match.Matchnr = hasGame.Matchnr inner join hasTeamMap c on c.SeasonId = hasGame.SeasonId and c.ForbLagId = hasGame.HemmalagId inner join hasTeamMap d on d.SeasonId = hasGame.SeasonId and d.ForbLagId = hasGame.BortalagId inner join hasTeam a on a.SeasonId = c.SeasonId and a.LagId = c.LagId inner join hasTeam b on b.SeasonId = d.SeasonId and b.LagId = d.LagId WHERE

SIFlogo.jpg   Elitserien 2001/2002
  www.swehockey.se

Round 49
Date Game Result   Spectators Venue Info
3/3/2002 4:00:00 Timrå IK - Linköpings HC 3 - 0 ( 1-0, 1-0, 1-0 ) 2109 Timrå Isstadion
3/3/2002 4:00:00 MIF Redhawks - Brynäs IF 3 - 7 ( 0-0, 1-4, 2-3 ) 5175 Malmö Isstadion
3/3/2002 4:00:00 Västra Frölunda HC - MODO Hockey 1 - 3 ( 0-1, 1-1, 0-1 ) 9740 Scandinavium
3/3/2002 4:00:00 Djurgårdens IF - HV 71 4 - 1 ( 0-0, 1-1, 3-0 ) 6950 Stockholm Globe Arena
3/3/2002 4:00:00 Färjestads BK - AIK 1 - 0 ( 0-0, 0-0, 0-0, 1-0 ) 7453 Löfbergs Lila Arena
3/3/2002 5:00:00 Luleå HF - Södertälje SK 3 - 2 ( 0-0, 3-1, 0-1 ) 4009 Delfinen