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   Allsvenskan Norra
  www.swehockey.se

Round 2
Date Game Result   Spectators Venue Info
9/24/2002 7:00:0 AIK - Hammarby IF 1 - 0 ( 0-0, 0-0, 0-0, 0-0, 1-0 ) 6332 Hovet, Johanneshov
9/25/2002 7:00:0 Skellefteå AIK - Bodens IK 4 - 2 ( 2-1, 1-0, 1-1 ) 3426 Skellefteå Kraft Arena
9/25/2002 7:00:0 Piteå HC - Team Kiruna IF 6 - 3 ( 2-1, 3-1, 1-1 ) 948 Isstadion LF Arena
9/25/2002 7:00:0 IF Björklöven - IF Vallentuna BK 3 - 0 ( 2-0, 0-0, 1-0 ) 2245 Umeå Arena
9/25/2002 7:00:0 Örnsköldsviks SK - IF Sundsvall Hockey 5 - 8 ( 1-3, 1-2, 3-3 ) 250 Kempehallen  
9/25/2002 7:00:0 IK Nyköpings NH 90 - Huddinge IK 5 - 6 ( 2-1, 1-1, 2-3, 0-0, 0-1 ) 1053 Rosvallahallen