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

Round 10
Date Game Result   Spectators Venue Info
10/5/1999 7:00:0 Brynäs IF - Västerås IK 6 - 0 ( 3-0, 1-0, 2-0 ) 3061 Gavlerinken  
10/12/1999 7:00: Djurgårdens IF - Linköpings HC 9 - 3 ( 4-0, 2-2, 3-1 ) 5709 Stockholm Globe Arena  
10/12/1999 7:00: Västra Frölunda HC - Färjestads BK 5 - 1 ( 3-1, 1-0, 1-0 ) 8501 Scandinavium  
10/12/1999 7:00: Luleå HF - Leksands IF 1 - 0 ( 1-0, 0-0, 0-0 ) 3937 Delfinen  
10/12/1999 7:00: MoDo Hockey - AIK 4 - 2 ( 1-1, 1-1, 2-0 ) 3842 Kempehallen  
10/12/1999 7:00: HV 71 - Malmö IF 1 - 3 ( 1-1, 0-1, 0-1 ) 3470 Rosenlundshallen