ホームページ >バックエンド開発 >PHPチュートリアル >MYSQL语句有关问题
MYSQL语句问题?
<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->UPDATE (SELECT WorkID,WK.PpjID,WD.CheckupPoint,WD.AdjustPoint,WD.FactPoint, WE.IsSpecial, WK.WorkType, WK.WorkStatus FROM `Work` WK LEFT JOIN WorkDesign WD ON WK.WorkID=WD.Work_idLEFT JOIN WorkEditionDot WE ON WE.EditionDotID=WE.EditionDotID WHERE `WK`.WorkID IN(SELECT `W`.WorkID FROM `Work` W WHERE W.PpjID=18035 AND (`W`.WorkStatus='已出稿' OR `W`.WorkStatus='已定稿'))) SET WD.CheckupPoint=WD.AdjustPoint+WD.FactPoint WHERE WK.PpjID=18035