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

Round 3
Date Game Result   Spectators Venue Info
9/24/1999 7:00:0 Lidingö HC - Hammarby IF 2 - 3 ( 1-1, 0-1, 1-0, 0-1 ) 477 Hovet, Johanneshov  
9/26/1999 4:00:0 Piteå HC - Skellefteå AIK 2 - 6 ( 1-2, 1-3, 0-1 ) 1686 Isstadion LF Arena  
9/26/1999 4:00:0 Timrå IK - Bodens IK 3 - 2 ( 3-0, 0-1, 0-1 ) 1851 Timrå Isstadion  
9/26/1999 4:00:0 IF Björklöven - IF Sundsvall Hockey 8 - 0 ( 2-0, 3-0, 3-0 ) 2193 Umeå Arena  
9/26/1999 4:00:0 Södertälje SK - Arlanda Wings HC 6 - 4 ( 2-1, 1-2, 3-1 ) 1360 Scaniarinken  
9/26/1999 4:00:0 Huddinge IK - IK Nyköpings NH 90 2 - 4 ( 0-2, 1-0, 1-2 ) 444 Björkängshallen