ForgotPassword?
Sign Up
Search this Topic:
Forum Jump
Posts: 98
01/21/10 10:09 PM
nemodomi wrote: Otie did you discover any sort of shortcut for digging up that kind of info? I tried googling, and exploring baseball-reference.com, but to no avail.
SELECT batting.playerID, master.nameFirst, master.nameLast, batting.yearID, Sum(batting.AB) AS SumOfAB, Sum(batting.HR) AS SumOfHR FROM batting INNER JOIN master ON batting.playerID = master.playerID GROUP BY batting.playerID, master.nameFirst, master.nameLast, batting.yearID HAVING (((Sum(batting.AB))=1) AND ((Sum(batting.HR))=1)) ORDER BY batting.yearID;
Share This