Major League Players Who Attended Texas A&M University

MLB Texas A&M University Player List

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