SQLite Forum

<code>update PenPals as pp set zip=(select kz.zip from KnownZips kz where kz.name=pp.name);</code>

Thank you very much, and to Keith as well.