update ds_store
set ds_store.sale_price=(select dd_medicineinfo.sale_price
from dd_medicineinfo
where ds_store.drug_code=dd_medicineinfo.drug_code
and ds_store.sale_price<>dd_medicineinfo.sale_price);
set ds_store.sale_price=(select dd_medicineinfo.sale_price
from dd_medicineinfo
where ds_store.drug_code=dd_medicineinfo.drug_code
and ds_store.sale_price<>dd_medicineinfo.sale_price);
update tableName
set
col1=someValue
where ...;
------------------
update tableName
set
col1=(select ...)
where ...;
update tableName
set
col1=someValue
where ...;
------------------
update tableName
set
col1=(select ...)
where ...;