update tabA t
set t.customerdesc=(select t3.customerdesc from tabB t3 where t.customerid=t3.customerid),
t.legalperson=(select t3.legalperson from tabB t3 where t.customerid=t3.customerid),
t.permitno=(select t3.permitno from tabB t3 where t.customerid=t3.customerid)
set t.customerdesc=(select t3.customerdesc from tabB t3 where t.customerid=t3.customerid),
t.legalperson=(select t3.legalperson from tabB t3 where t.customerid=t3.customerid),
t.permitno=(select t3.permitno from tabB t3 where t.customerid=t3.customerid)