如何批量更新一个表中某一字段的值为另一表某一字段的值 ???

如何批量更新一个表中某一字段的值为另一表某一字段的值 ???http://community.csdn.net/Expert/topic/3308/3308019.xml?temp=.7126276上面例子里的是1个列的，我要的是两个列的，请问怎么搞？UPDATE BD_REQUEST_DATA_PUSET BD_REQUEST_DATA_PU.MATERIAL_CAT = BD_Material_Master.CATEGORY_NO,SET BD_REQUEST_DATA_PU.MATERIAL_NAME = BD_Material_Master.MATERIAL_NAME FROM BD_Material_MasterWHERE BD_REQUEST_DATA_PU.MATERIAL_NO = BD_Material_Master.MATERIAL_NO试试UPDATE ASET A.MATERIAL_CAT = B.CATEGORY_NO,A.MATERIAL_NAME = B.MATERIAL_NAME FROM BD_REQUEST_DATA_PU A Inner Join BD_Material_Master BOn A.MATERIAL_NO = B.MATERIAL_NO