Loading ...
Sorry, an error occurred while loading the content.
 

Re: retroID in the master table including other errors

Expand Messages
  • tangotiger
    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
    Message 1 of 12 , Aug 30, 2008
      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
      >
    Your message has been successfully submitted and would be delivered to recipients shortly.