Major League Players Who Attended University of San Francisco

MLB University of San Francisco Player List

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