Paul:

Do you know where I might find the Lahman sample queries?  I have the DB but can’t seem to locate the samples.

Thanks,

CJH

PS you make a good point about the 3b issue,  I was going to require 100G at the position. . . .

Thanks, Paul

CJH

> According to Lee Sinins sabermetric encyclopedia,
> 1    Mike Schmidt                515  
> 2    Eddie Mathews               502 
> 3    Graig Nettles               378 
> 4    Matt Williams               370
> 5    Gary Gaetti                 360
> 6    Ron Santo                   337
> 7    Ron Cey                     312
> 8    Vinny Castilla              303  

In reply to CJ on SABR-L, i explained what can be done by following
the sample queries that are included in the MS Access database
distributed by Sean Lahman.  I closed,
>>
But CJ Haddick needs "all 3b with more than 100G" to begin with.  That
is not easy, for the database does not identify batting records with
fielding positions as it identifies them with teams.  Indeed, beyond
the scope of a particular lineup there is no agreement on what a "3b"
or thirdbaseman is.

It is easy to select from the Fielding table everyone with 100 or more
career games played at thirdbase. . . . But selecting every "3b with
more than 100G" is like inventing a new way to catch fish where you
aren't sure whether a whale or a shark or a shrimp is a fish.
<<

Evidently, Sinins identifies players with fielding positions, at least
at the career level.  That can only be controversial.  In real life,
you need to think about what you mean --probably in reference to real
players such as Harmon Killebrew, Dick Allen, Tony Perez, Joe Torre,
and someone who played 40% third 30% left 30% right-- *and then* use
some database management ingenuity.

For homeruns hit as a thirdbaseman (where alone I know that people
speak of alltime records) you need game-level detail that is available
only in the SABR Home Run Log.  That covers all but a few home runs in
major league history from 1871, with data at the inning level.

Paul Wendt