SQL 2008中的多表更新

Question

我正在犯错误：

(Msg 102，第15级，状态1，第1行，在“I”附近不正确的语法)。在执行SQL查询时。

如果我哪里错了，请告诉我。

UPDATE tbl_Item I
LEFT JOIN  tbl_Batch B ON  I.Batchuid = B.Batchuid 
LEFT JOIN  tbl_ICLExtCashLetter C ON  B.ICLExtCashLetterUID =  C.ICLExtCashLetteruid
LEFT JOIN  tbl_ICLExtFile F ON F.ICLExtFIleUId = C.ICLExtFileUId
Set MarkICLDone = 0
WHERE F.FileName = @FileName 

1. 带有ID的tbl_ICLExtFile (PK) = Tbl_ICLExtCashletter (FK)
2. 带有ID的tbl_ICLExtCashletter (PK) = tbl_Batch (FK)
3. 带有ID的tbl_Batch (PK) = tbl_Item(FK)

Answer 1

在使用Server时，您正在使用MySQL语法进行更新。我假设您已经设置了变量@FileName的值。Server多表联接更新的语法如下所示。

UPDATE I
Set MarkICLDone = 0
FROM   tbl_Item I     
LEFT JOIN  tbl_Batch B 
   ON  I.Batchuid = B.Batchuid 
LEFT JOIN  tbl_ICLExtCashLetter C 
   ON  B.ICLExtCashLetterUID =  C.ICLExtCashLetteruid
LEFT JOIN  tbl_ICLExtFile F 
   ON F.ICLExtFIleUId = C.ICLExtFileUId

WHERE F.FileName = @FileName