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 2000/2001
  www.swehockey.se

Round 6
Date Game Result   Spectators Venue Info
10/5/2000 7:00:0 Timrå IK - AIK 4 - 3 ( 1-1, 1-1, 1-1, 1-0 ) 4330 Timrå Isstadion
10/5/2000 7:00:0 Västra Frölunda HC - Leksands IF 6 - 3 ( 1-1, 1-2, 4-0 ) 5741 Scandinavium
10/5/2000 7:00:0 Brynäs IF - Luleå HF 3 - 4 ( 0-0, 1-3, 2-1 ) 4222 Gavlerinken
10/5/2000 7:00:0 Djurgårdens IF - HV 71 4 - 1 ( 1-1, 1-0, 2-0 ) 4525 Stockholm Globe Arena
10/5/2000 7:00:0 Färjestads BK - MoDo Hockey 5 - 2 ( 1-2, 4-0, 0-0 ) 3611 Färjestads Ishall
10/5/2000 7:00:0 IF Björklöven - Malmö IF 1 - 4 ( 1-1, 0-2, 0-1 ) 2727 Umeå Arena