UPDATE RptCx LEFT JOIN PlanStatus ON (RptCx.DesignID = PlanStatus.DesignID) AND (RptCx.PatternID = PlanStatus.PatternID) SET RptCx.Total1 = PlanStatus.DoneNum
...全文
236打赏收藏
各位大侠,帮忙改一下SQL语句
下面这个语句在ACCESS是可以的,现在SQL SERVER怎么实现这个功能 UPDATE RptCx LEFT JOIN PlanStatus ON (RptCx.DesignID = PlanStatus.DesignID) AND (RptCx.PatternID = PlanStatus.PatternID) SET RptCx.Total1 = PlanStatus.DoneNum
剛才有個地方寫錯了,現更正如下:
UPDATE RptCx SET Total1 = PlanStatus.DoneNum
from RepCx LEFT JOIN PlanStatus ON RptCx.DesignID = PlanStatus.DesignID AND RptCx.PatternID = PlanStatus.PatternID
UPDATE RptCx SET RptCx.Total1 = PlanStatus.DoneNum
from RepCx LEFT JOIN PlanStatus ON RptCx.DesignID = PlanStatus.DesignID AND RptCx.PatternID = PlanStatus.PatternID