Quote:
Originally Posted by actionjackson
How did R A Dickey get lumped in there then?  |
This is part of the how:SELECT [750PitchingCareer].playerID, [300/50MinimumBatting].SumOfG AS BattingGames, IIf([300/50MinimumBatting.sumofg] Is Null,1,[sumofg]/[300/50MinimumBatting.sumofg]) AS KillThesePitchingRecords, [300/50MinimumBatting].TooFew300G, CInt(([sumofipouts]/[sumofg])*[toofew300g]) AS NewIPOuts, [750PitchingCareer].SumOfG, [750PitchingCareer].SumOfIPouts, [750PitchingCareer].SumOfW, CInt(([sumofw]/[sumofg])*[toofew300g]) AS NewW, [750PitchingCareer].SumOfL, CInt(([sumofl]/[sumofg])*[toofew300g]) AS NewL, [750PitchingCareer].SumOfGS, CInt(([sumofgs]/[sumofg])*[toofew300g]) AS NewGS, [750PitchingCareer].SumOfCG, CInt(([sumofcg]/[sumofg])*[toofew300g]) AS NewCG, [750PitchingCareer].SumOfNewSHO, CInt(([sumofnewsho]/[sumofg])*[toofew300g]) AS NewSho, [750PitchingCareer].SumOfSV, CInt(([sumofsv]/[sumofg])*[toofew300g]) AS NewSV, [750PitchingCareer].SumOfNewH, CInt(([sumofnewH]/[sumofg])*[toofew300g]) AS NewH, [750PitchingCareer].SumOfnewER, CInt(([sumofnewer]/[sumofg])*[toofew300g]) AS NewER, [750PitchingCareer].SumOfNewHR, CInt(([sumofnewHR]/[sumofg])*[toofew300g]) AS NewHR, [750PitchingCareer].SumOfnewbb, CInt(([sumofnewbb]/[sumofg])*[toofew300g]) AS NewBB, [750PitchingCareer].SumOfnewso, CInt(([sumofnewso]/[sumofg])*[toofew300g]) AS NewSO, [750PitchingCareer].SumOfnewibb, CInt(([sumofnewibb]/[sumofg])*[toofew300g]) AS NewIBB, [750PitchingCareer].SumOfnewwp, CInt(([sumofnewwp]/[sumofg])*[toofew300g]) AS NewWP, [750PitchingCareer].SumOfnewhbp, CInt(([sumofnewhbp]/[sumofg])*[toofew300g]) AS NewHBP, [750PitchingCareer].SumOfnewbk, CInt(([sumofnewbk]/[sumofg])*[toofew300g]) AS NewBK, [750PitchingCareer].SumOfBFP, CInt(([sumofbfp]/[sumofg])*[toofew300g]) AS NewBFP, [750PitchingCareer].SumOfGF, CInt(([sumofgf]/[sumofg])*[toofew300g]) AS NewGF, [750PitchingCareer].SumOfnewr, CInt(([sumofnewr]/[sumofg])*[toofew300g]) AS NewR, [750PitchingCareer].SumOfnewsh, CInt(([sumofnewsh]/[sumofg])*[toofew300g]) AS NewSH, [750PitchingCareer].SumOfnewsf, CInt(([sumofnewsf]/[sumofg])*[toofew300g]) AS NewSF, [750PitchingCareer].SumOfnewgidp, CInt(([sumofnewgidp]/[sumofg])*[toofew300g]) AS NewGIDP
FROM [300/50MinimumBatting] RIGHT JOIN 750PitchingCareer ON [300/50MinimumBatting].playerID = [750PitchingCareer].playerID
WHERE (((IIf([300/50MinimumBatting.sumofg] Is Null,1,[sumofg]/[300/50MinimumBatting.sumofg]))>0.02))
ORDER BY [750PitchingCareer].playerID;