Major League Players Who Attended Emporia State University

MLB Emporia State University Player List

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