Mayhaps, update itms set std_nm = (select std_nm from aliases where raw_nm=itms.raw_nw) where exists (select 1 from aliases where raw_nm=itms.raw_nw);
which translates to english as: for each row in itms where there exists a row in aliases where aliases.raw_nm=itms.raw_nm set itms.raw_nm to aliases.std_nm where aliases.raw_nm=itms.raw_nm This UPDATE itms SET std_nm=(SELECT std_nm FROM aliases as x WHERE raw_nm = x.raw_nm) translates to english as: for each row in itms set itms.std_nm to the std_nm located in the first row of aliases where aliases.raw_nm=aliases.raw_nm >-----Original Message----- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of dean gwilliam >Sent: Monday, 7 October, 2013 05:48 >To: sqlite-users@sqlite.org >Subject: [sqlite] updating using a value from another table > >Here it is >tbl itms (std_nm text, raw_nm text) >tbl aliases (std_nm text, raw_nm text) > >Id like to whip through table itms which has a blank col std_nm and fill >in as many fields as I can >by >reading each itms' raw_nm fld >finding any matching rec (with the same raw_nm value) in aliases >updating the std_nm fld in itms with corresponding std_nm value in the >matching fld in aliases > >Here's my miserable attempt >gDb eval "UPDATE itms SET std_nm=(SELECT std_nm FROM aliases as x WHERE >raw_nm = x.raw_nm);" > >Any help much appreciated >_______________________________________________ >sqlite-users mailing list >sqlite-users@sqlite.org >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users