<code>create table PenPals(name text, street text, zip text);
insert into PenPals(name) values ('Fran'),('George');
create table KnownZips(name text, zip text);
insert into KnownZips(name,zip) values ('George','12345'),('Fran','67890');
update PenPals as pp set zip=(select kz.zip from KnownZips kz where kz.name=pp.name);
.header on
select name, zip from PenPals;
name|zip
Fran|67890
George|12345
</code>