Major League Players Who Attended University of South Carolina

MLB University of South Carolina Player List

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