I have 2 tables: wide and narrow.
Narrow table has 2 columns: inn, custid
Wide table has many columts, among them are similar inn, custid.

I want to set
wide.custid=narrow.custid
in those rows of wide, where
wide.inn=narrow.inn

MySQL ver 3.23.51

Thanks.

the multi-table update syntax is in version 4.0

you'll need a scripting language and a loop

Thank you very much!!!