For those interested, do this:
1. Take the data below, and create a table called MasterRookies, with
two fields (playerID, retroID), and copy the data into that table.
It's a snap in Access.

2. Run this:
UPDATE Master
INNER JOIN MasterRookies
ON Master.playerID = MasterRookies.playerID
SET Master.retroID = [masterRookies].[retroid];

That will update your MASTER table. That's in Access. Some DBMS
won't let you do the join on the UPDATE. In that case, you have to
use a WHERE EXISTS clause. It'll be something like:
UPDATE Master
SET Master.retroID = (
SELECT retroid
FROM MasterRookies
WHERE Master.playerID = MasterRookies.playerID
)
WHERE EXISTS (
SELECT retroid
FROM MasterRookies
WHERE Master.playerID = MasterRookies.playerID
)

I didn't test that last one, but that should work. It's kinda silly,
and maybe someone can offer something better.

Tom

--- In baseball-databank@yahoogroups.com, "Tangotiger" <tom@...> wrote:
>
> Someone, I think Rod, asked me a long while back for my list of
Retro/BDB
> mappings for the new players. This is my unofficial list:
>
> playerID retroid
> abreuto01 abret001
> acostma01 acosm001
> albaljo01 albaj001
> anderjo03 andej004
> ariasal02 ariaa002
> ascanjo01 ascaj001
> baileho02 bailh001
> baileje01 bailj001
> balenwl01 balew001
> banksjo01 bankj001
> bardebr01 bardb001
> barkese01 barks001
> baronda01 barod001
> bartoda02 bartd001
> basakch01 basac001
> belloed01 belle002
> bisenjo01 bisej001
> blackni01 blacn001
> blevije01 blevj001
> bonifem01 bonie001
> bradeda01 bradd002
> braunry02 braur002
> broadla01 broal001
> brownma05 browm006
> buchhcl01 buchc001
> bucknbi02 buckb002
> bucktr01 buckt001
> buddery01 buddr001
> burtoja01 burtj001
> buschbr01 buscb001
> butlebi03 butlb003
> cabreas01 cabra002
> camerke01 camek001
> carrobr01 carrb001
> casseja01 cassj001
> castoko01 castk001
> catetr01 catet001
> cavazan01 cavaa001
> chambjo03 chamj002
> cherrro01 cherr001
> chicoma01 chicm001
> clarkda06 clard003
> clemeje01 clemj001
> clippty01 clipt001
> collawi01 collw001
> coutljo01 coutj001
> danksjo01 dankj001
> davidda01 david003
> dayde01 day-d001
> deazaal01 deaza001
> dejonjo01 dejoj001
> delaceu01 delae001
> depauju01 depaj003
> desalma01 desam001
> detwiro01 detwr001
> dovede01 doved001
> doyneco01 doync001
> dukesel01 dukee001
> dumatph01 dumap001
> duncash01 duncs001
> ellsbja01 ellsj001
> escobyu01 escoy001
> esposbr01 espob001
> evanste01 evant002
> floreje02 florj002
> foxja02 fox-j001
> francbe01 franb001
> fuldsa01 fulds001
> galarar01 galaa002
> gallase01 galls001
> gallayo01 gally001
> garcian01 garca002
> garciha01 garch001
> gieseda01 giesd001
> gomezca01 gomec002
> gonzaal03 gonza005
> gonzaan01 gonza004
> gordoal01 gorda001
> gorneni01 gornn001
> gronkle01 gronl001
> gutieju01 gutij002
> gwynma01 gwynm001
> hamiljo03 hamij003
> hanigry01 hanir001
> hanrajo01 hanrj001
> happja01 happj001
> hartke01 hartk001
> haynena01 haynn001
> headlch01 headc001
> hernalu01 hernl004
> hernayo01 herny001
> hochelu01 hochl001
> huch01 hu--c001
> hugheph01 hughp001
> huller01 hulle001
> igawake01 igawk001
> iwamuak01 iwama001
> jimenke01 jimek001
> johnsro07 johnr009
> jonesbr02 joneb005
> jonesga02 joneg002
> jurrjja01 jurrj001
> kellydo01 kelld001
> kendrky01 kendk001
> kenneia01 kenni001
> koshajo01 koshj001
> kuwatma01 kuwam001
> laffeaa01 laffa001
> lannajo01 lannj001
> larocan01 laroa002
> lewisje01 lewij003
> linceti01 linct001
> lindsma01 lindm001
> litscje01 litsj001
> lizra01 liz-r001
> lucydo01 lucyd001
> maciadr01 macid001
> maharke01 mahak001
> marshja01 marsj001
> matsuda01 matsd001
> maxweju01 maxwj002
> maybica01 maybc001
> mcbetma01 mcbem001
> mccleza01 mcclz001
> mclemma02 mclem003
> melilke01 melik001
> meloajo01 meloj002
> mendolu01 mendl001
> metcatr01 metct001
> milleja03 millj003
> molingu01 molig002
> moralfr01 moraf001
> moraljo02 moraj002
> morgany01 morgn001
> morrobr01 morrb001
> mortoco01 mortc001
> mossbr01 mossb001
> munizca01 munic001
> murphbi02 murpb001
> murraaj01 murra001
> mussene01 mussn001
> newmajo01 newmj002
> ohlenro01 ohler001
> okajihi01 okajh001
> olsonga01 olsog003
> owingmi01 owinm001
> parrama01 parrm001
> patteer01 patte001
> pattotr01 pattt001
> paulife01 paulf001
> pearcst01 pears001
> pegueja01 peguj002
> pencehu01 pench001
> petribi01 petrb002
> phillhe01 philh001
> piefe01 pie-f001
> pignaca01 pignc001
> putnada01 putnd001
> ramired01 ramie003
> rapadcl01 rapac001
> reyesjo03 reyej003
> reynoma01 reynm001
> richada02 richd001
> ridgwje01 ridgj001
> roberco01 robec002
> rodrigu01 rodrg001
> rowlary01 rowlr002
> ruggiju01 ruggj001
> ryanbr01 ryanb002
> salmobr01 salmb001
> saltaja01 saltj001
> sammocl01 sammc001
> sanchro01 sancr002
> sardibr01 sardb001
> schiena01 schin001
> schulmi02 schum001
> seddoch01 seddc001
> segovza01 segoz001
> shearto01 sheat001
> sloweke01 slowk001
> smithjo05 smitj002
> smithse01 smits002
> sonnaan01 sonna001
> soriajo01 sorij001
> speigle01 speil001
> stanscr01 stanc001
> stettmi01 stetm001
> stewaia01 stewi001
> stockme01 stocm001
> suzukku01 suzuk001
> thatcjo01 thatj001
> thigpcu01 thigc001
> thompri03 thomr006
> threeer01 three001
> towlejr01 towlj001
> uptonju01 uptoj001
> vanderi01 vandr001
> vasquvi01 vasqv001
> velezeu01 velee001
> vermija01 vermj001
> vottojo01 vottj001
> wasseeh01 wasse001
> watkito01 watkt001
> whitebi04 whitb001
> whitese02 whits002
> wolfebr01 wolfb001
> wolfro01 wolfr002
> woodbr01 woodb003
> wrighch01 wrigc001
> zagurmi01 zagum001
> zaratma01 zaram001
>
> Tom
>