以下语句在SQL2005中执行是成功的,在狐表中却执行不了?
UPDATE A SET A.需求交期 = B.需求日期 FROM {jit_mrp} As A INNER JOIN (Select 物料编码,min(需求日期) As 需求日期 from {jit_vmos} group by 物料编码) As B ON A.物料编码 = B.物料编码