Major League Players Who Attended University of New Haven

MLB University of New Haven Player List

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