"Greg Robertson" <trifus...@gmail.com>
wrote in message
news:151e70a00902231534h37d10202m469a176d704d6...@mail.gmail.com
> I have two tables each with two fields:
>
> TableA: Field1, Field2
>
> TableB: Field3, Field4
>
>
> I would like to set Field2 in TableA to the value in Field4 in TableB
> where TableA.Field3=TableB.Field4
I'm confused which field is in which table. Your description is
self-contradictory. Anyway, you want something like this (columns
renamed in an obvious way for clarity):
update TableA set A2 =
(select B2 from TableB where A1=B1)
where A1 in (select B1 from TableB);
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
