YAHOO ELIGIBILITY

[Bloody Nipples]

Thanks Amazinz! Coming to the rescue yet again with the Lahman Database!

[Amazinz]

Yeah I love it. I really need to get around to donating as much as I use it.

Here are DHs:

Allen Chad DH
Alomar Roberto DH
Anderson Garret DH
Baldelli Rocco DH
Berg Dave DH
Bloomquist Willie DH
Bonds Barry DH
Burks Ellis DH
Catalanotto Frank DH
Crawford Carl DH
Crisp Coco DH
Crozier Eric DH
Cummings Midre DH
Davanon Jeff DH
Delgado Carlos DH
Dellucci David DH
Durazo Erubiel DH
Everett Carl DH
Fick Robert DH
Ford Lew DH
Fullmer Brad DH
Giambi Jason DH
Gibbons Jay DH
Glaus Troy DH
Gload Ross DH
Gross Gabe DH
Guerrero Vladimir DH
Guillen Jose DH
Hafner Travis DH
Hairston Jerry DH
Hansen Dave DH
Harvey Ken DH
Higginson Bobby DH
Huff Aubrey DH
Hunter Torii DH
Jacobsen Bucky DH
Jones Chipper DH
Jordan Brian DH
Karros Eric DH
Kielty Bobby DH
Konerko Paul DH
Kubel Jason DH
LeCroy Matt DH
Lee Carlos DH
Leon Jose DH
Lopez Javy DH
Lopez Luis DH
Lugo Julio DH
Martinez Victor DH
Martinez Edgar DH
Martinez Tino DH
McCracken Quinton DH
McDonald John DH
McGriff Fred DH
McMillon Billy DH
Mench Kevin DH
Menechino Frank DH
Millar Kevin DH
Molina Ben DH
Morneau Justin DH
Munson Eric DH
Newhan David DH
Norton Greg DH
Offerman Jose DH
Ordonez Magglio DH
Ortiz David DH
Palmeiro Rafael DH
Pena Carlos DH
Perez Timo DH
Perry Herb DH
Phelps Josh DH
Piazza Mike DH
Pickering Calvin DH
Pond Simon DH
Ramirez Manny DH
Randa Joe DH
Restovich Michael DH
Roberts Brian DH
Rodriguez Ivan DH
Ryan Michael DH
Salmon Tim DH
Segui David DH
Sheffield Gary DH
Shelton Chris DH
Sierra Ruben DH
Simon Randall DH
Stairs Matt DH
Stewart Shannon DH
Surhoff B.J. DH
Sweeney Mike DH
Thames Marcus DH
Thomas Frank DH
Thome Jim DH
Upton B.J. DH
White Rondell DH
Williams Bernie DH
Young Dmitri DH
Young Eric DH

[ironman]

Awesome, thanks Amazinz!

[ensanimal]

wow, good stuff amazinz, this will come in handy

[RynMan]

Amazinz, just curious....does the Lahman database have a position column?

[Bloody Nipples]

Amazinz, just curious....does the Lahman database have a position column?

It has a separate record/row for each position a player had experience at for each year. There is a "# of games played" column, too. So what Amazinz must have done was to extract all the records for one player that had at least 5 games played, and then combine them into one record (the last part is a bit complicated).

[Amazinz]

Yeah what Nipples said. Here it is for anyone who wants it. You can use it for a non-Yahoo league, just change the number 4 to whatever you need.

Query#1 "04FieldingALL"

SELECT Master.playerID, Master.nameLast, Master.nameFirst, IIf(Sum(IIf(Fielding.POS="C",Fielding.G,0))>14,"C ","") & IIf(Sum(IIf(Fielding.POS="1B",Fielding.GS,0))>4,"1B ","") & IIf(Sum(IIf(Fielding.POS="2B",Fielding.GS,0))>4,"2B ","") & IIf(Sum(IIf(Fielding.POS="3B",Fielding.GS,0))>4,"3B ","") & IIf(Sum(IIf(Fielding.POS="SS",Fielding.GS,0))>4,"SS ","") & IIf(Sum(IIf(Fielding.POS="LF",Fielding.GS,0))>4,"LF ","") & IIf(Sum(IIf(Fielding.POS="CF",Fielding.GS,0))>4,"CF ","") & IIf(Sum(IIf(Fielding.POS="RF",Fielding.GS,0))>4,"RF ","") & IIf(Sum(IIf(Fielding.POS="DH",Fielding.G,0))>4,"DH ","") AS POS
FROM Master INNER JOIN Fielding ON Master.playerID=Fielding.playerID
WHERE (((Fielding.yearID)=2004))
GROUP BY Master.playerID, Master.nameLast, Master.nameFirst
ORDER BY Master.nameLast ASC;

Query#2 "04Fielding"

SELECT * FROM 04FieldingALL WHERE POS<>""

The second query just gets rid of all the pitchers.

[RynMan]

Yeah what Nipples said. Here it is for anyone who wants it. You can use it for a non-Yahoo league, just change the number 4 to whatever you need.

Query#1 "04FieldingALL"

SELECT Master.playerID, Master.nameLast, Master.nameFirst, IIf(Sum(IIf(Fielding.POS="C",Fielding.G,0))>14,"C ","") & IIf(Sum(IIf(Fielding.POS="1B",Fielding.GS,0))>4,"1B ","") & IIf(Sum(IIf(Fielding.POS="2B",Fielding.GS,0))>4,"2B ","") & IIf(Sum(IIf(Fielding.POS="3B",Fielding.GS,0))>4,"3B ","") & IIf(Sum(IIf(Fielding.POS="SS",Fielding.GS,0))>4,"SS ","") & IIf(Sum(IIf(Fielding.POS="LF",Fielding.GS,0))>4,"LF ","") & IIf(Sum(IIf(Fielding.POS="CF",Fielding.GS,0))>4,"CF ","") & IIf(Sum(IIf(Fielding.POS="RF",Fielding.GS,0))>4,"RF ","") & IIf(Sum(IIf(Fielding.POS="DH",Fielding.G,0))>4,"DH ","") AS POS
FROM Master INNER JOIN Fielding ON Master.playerID=Fielding.playerID
WHERE (((Fielding.yearID)=2004))
GROUP BY Master.playerID, Master.nameLast, Master.nameFirst
ORDER BY Master.nameLast ASC;

Query#2 "04Fielding"

SELECT * FROM 04FieldingALL WHERE POS<>""

The second query just gets rid of all the pitchers.

I can use it semi-well in the query design wizard thing....but that scares me.

[Amazinz]

Instead of the designer just flip it over to SQL and then copy and paste what I posted. It looks more complicated than it is all jumbled up like that.

[RynMan]

Instead of the designer just flip it over to SQL and then copy and paste what I posted. It looks more complicated than it is all jumbled up like that.

Yeah, it just doesnt allow me to feel intelligent enough to do it myself. Im a big kid now!