update fa_yao set b.med_name=a.medname,b.buy_price=a.buy_price,b.spec=a.spec,b.unit=a.unit
from t_drugshop_in_hospital a,fa_yao b where a.id=b.id
from t_drugshop_in_hospital a,fa_yao b where a.id=b.id
from t_drugshop_in_hospital a,fa_yao b where a.id=b.id