"Greg Robertson" <trifus...@gmail.com> wrote in message news:151e70a00902231728j608612b8n491e84b11c70c...@mail.gmail.com > That did it. > > Thanks > > Greg > > On Mon, Feb 23, 2009 at 7:05 PM, Griggs, Donald > <donald.gri...@allscripts.com> wrote: >> Hi Greg, >> >> Someone on the list may give a better reply, and I'm sending this to >> you >> directly, but I think the following will work: >> >> Update tableA >> set Field2 = ( select Field4 from tableB >> where TableA.Field3=TableB.Field4 );
If there are any rows in tableA without a matching row in tableB, this would set Field2 in all such rows to NULL. This may or may not matter in your case, of course. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
