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_id
LEFT 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报错;Every derived table must have its own alias该如何解决(别名问题)?
(
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_id
LEFT 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报错;Every derived table must have its own alias该如何解决(别名问题)?
update a SET CheckupPoint=a.AdjustPoint+a.FactPoint
from WorkDesign a right join Wrok b on a.Work_id=b.WorkId
WHERE b.PpjID=18035 and (b.WorkStatus='已出稿' OR b.WorkStatus='已定稿')
mysql就不知道了
--try
update
a,b
SET
CheckupPoint=a.AdjustPoint+a.FactPoint
from
WorkDesign a right join Wrok b on a.Work_id=b.WorkId
WHERE
b.PpjID=18035 and (b.WorkStatus='已出稿' OR b.WorkStatus='已定稿')
WorkDesign a right join Wrok b on a.Work_id=b.WorkId
SET
CheckupPoint=a.AdjustPoint+a.FactPoint
WHERE
b.PpjID=18035 and (b.WorkStatus='已出稿' OR b.WorkStatus='已定稿')
(
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_id
LEFT 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='已定稿'))) t
SET CheckupPoint=AdjustPoint+FactPoint WHERE PpjID=18035