2012-07-19
方法一:update a seta.OrdQty=b.OrdQty,a.RDate=b.RDate,a.TiHuostate=b.TiHuostate,a.TiHuoSiJi=b.TiHuoSiJi,a.TiHuoDate=b.TiHuoDate,a.ShiJiDGCdate=b.ShiJiDGCdate,a.HUIDdate=b.HUIDdate,a.DanJFanhuiBJdate=b.DanJFanhuiBJdate,a.BeiZhu=b.BeiZhuFROM (select a.DOATHno,MAX(b.OrdQty),MAX(b.RDate),MAX(b.TiHuostate), MAX(b.TiHuoSiJi),MAX(b.TiHuoDate),MAX(b.ShiJiDGC...