LifeinAsia - 8:16 pm on Feb 21, 2011 (gmt 0)

Oops- I missed this the first time through:

FROM idihc_seasons S, idihc_playerpositions LEFT OUTER JOIN idihc_players P ON P.PlayerID = S.SeasonPlayerID LEFT OUTER JOIN idihc_seasonnames SN ON SN.SeasonID = S.SeasonID LEFT OUTER JOIN idihc_playerpositions ON P.PlayerPositionID = idihc_playerpositions.PlayerPositionID

You are joining the same table twice. You can do that, but you'll need to use different table aliases for each one.