"Greg Robertson" <[email protected]> wrote in message news:[email protected] > That did it. > > Thanks > > Greg > > On Mon, Feb 23, 2009 at 7:05 PM, Griggs, Donald > <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
