Major League Players Who Attended University of North Carolina at Chapel Hill

MLB University of North Carolina at Chapel Hill Player List

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