查询一张表的一个字段数据，批改另一张表的字段数据
查询一张表的一个字段数据，修改另一张表的字段数据
UPDATE bd_material as bd
SET bd.PRICE= (SELECT mp.price from material_price as mp where mp.MATERIAL_ID =bd.id )
WHERE bd.ID IN (SELECT tt.MATERIAL_ID from material_price as tt)
这条语句感觉不好临时用，又明白的将其该简单点，谢谢了。
SET bd.PRICE= (SELECT mp.price from material_price as mp where mp.MATERIAL_ID =bd.id )
WHERE bd.ID IN (SELECT tt.MATERIAL_ID from material_price as tt)
这条语句感觉不好临时用，又明白的将其该简单点，谢谢了。