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

HockeyAllsvenskan [Back]

Round 2
Date Game Result   Spectators Venue Info
9/18/2009 7:00:0 Borås HC - Bofors IK 2 - 4 ( 0-2, 2-1, 0-1 ) 1120 Borås Ishall  
9/18/2009 7:00:0 Leksands IF - Växjö Lakers HC 4 - 0 ( 2-0, 1-0, 1-0 ) 6636 Ejendals Arena  
9/18/2009 7:00:0 IF Malmö Redhawks - Mora IK 3 - 5 ( 0-1, 2-3, 1-1 ) 6639 Malmö Arena  
9/19/2009 4:00:0 IK Oskarshamn - IF Troja/Ljungby 3 - 2 ( 0-1, 1-0, 2-1 ) 2282 Arena Oskarshamn  
9/19/2009 6:00:0 IF Björklöven - IF Sundsvall Hockey 4 - 1 ( 0-0, 2-0, 2-1 ) 2581 Umeå Arena  
9/21/2009 7:00:0 Almtuna IS - VIK Västerås HK 2 - 1 ( 1-0, 0-0, 1-1 ) 1613 Gränbyhallen  
9/21/2009 7:00:0 Örebro HK - A I K  IF 1 - 5 ( 1-3, 0-0, 0-2 ) 2057 Behrn Arena