update A set BizNetPoint_MostlyWare=B.BizNetPoint_MostlyWare from B where A.BizNetPoint_Name =B.BizNetPoint_Name
update A set A.BizNetPoint_MostlyWare= (select B.BizNetPoint_MostlyWare from B where B.BizNetPoint_Name=A.BizNetPoint_Name ) from B where A.BizNetPoint_Name in (select BizNetPoint_Name from b)
set BizNetPoint_MostlyWare=B.BizNetPoint_MostlyWare
from B
where A.BizNetPoint_Name =B.BizNetPoint_Name
set A.BizNetPoint_MostlyWare=
(select B.BizNetPoint_MostlyWare from B where
B.BizNetPoint_Name=A.BizNetPoint_Name
)
from B where A.BizNetPoint_Name in (select BizNetPoint_Name from b)
而且有的字段是A表还是B表不明确