SELECT nhlsalaries.PlayerName, players.PlayerID, players.Position, nhlsalaries.Year2012, teams.Team, teams.TeamName, teams.TeamCity, players.TeamID
				FROM (teams INNER JOIN players ON teams.TeamID = players.TeamID) INNER JOIN nhlsalaries ON players.PlayerID = nhlsalaries.PlayerID
				WHERE (((players.TeamID)= 12) AND ((nhlsalaries.Year2012)<> 0))
				ORDER BY s2011<br/><br/>Unknown column 's2011' in 'order clause'