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