Christ The King - FC

The Official Website

The Team   :   Our Pitch   :  How to Join   :  Rules of Conduct   :  Gallery

Goal keepers

 

SELECT FBPlayers.PlayerID, FBPlayers.Name, FBPlayers.Photo, ComboList.Item AS [Position], ComboList.Item2 FROM FBPlayers LEFT JOIN ComboList ON FBPlayers.Position = ComboList.ComboID WHERE (((FBPlayers.TeamID)=1) AND ((FBPlayers.Status)=0) AND ((ComboList.Item2)=1));

 

Player

Position

 A Kavanagh

Goal Keeper