Major League Players Who Attended Colgate University

MLB Colgate University Player List

SELECT m.nameFirst as firstname, m.nameLast as lastname, sp.playerID as theplayerid FROM People m, SchoolsPlayers sp WHERE sp.schoolID = 'colgate' AND sp.playerID = m.playerID ORDER BY lastname LIMIT 200