我觉得这样可行一点
UPDATE oldequipment SET oldequipment.eqID=equipment.eqID,
oldequipment.eqtype=equipment.eqtype,
oldequipment.eqNUM=equipment.eqNUM,
oldequipment.eqMONEY=equipment.eqMONEY,
where
oldequipment='ce2005' and
equipemnt='ce2006'
我也不十分清楚，你试试下面这个嵌套语句：
UPDATE oldequipment SET eqID=(SELECT eqID FROM equipment WHERE quID='ce2006') WHERE eqID='2005'
