大家帮我看看这段SQL代码，是一个关于UPDATE的，谢谢！

[Iris]

UPDATE [STE]
SET [FCDATE]='AA'
WHERE [STE].[VENDOR] = XSECT.[BUMO]
AND XSECT.[GKU] = 0
AND [STE].[FCDATE] = NULL

我想更新STE表的FCDATE字段，限制条件时用到XSECT表
执行时错误：列前缀 'XSECT' 与查询中所用的表名或别名不匹配。
给怎么写呢？
谢谢

[97866]

UPDATE [STE]
SET [FCDATE]='AA' From XSECT
WHERE [STE].[VENDOR] = XSECT.[BUMO]
AND XSECT.[GKU] = 0
AND [STE].[FCDATE] = NULL

[sdhdy]

UPDATE [STE]
SET [FCDATE]='AA' from XSECT
WHERE [STE].[VENDOR] = XSECT.[BUMO]
AND XSECT.[GKU] = 0
AND [STE].[FCDATE] is NULL

[yujohny]

UPDATE A
SET A.[FCDATE]='AA'
FROM [STE] A,XSECT B
WHERE A.[VENDOR] = B.[BUMO]
AND B.[GKU] = 0
AND A.[FCDATE] IS NULL

[playyuer]

UPDATE [STE]
SET [FCDATE]='AA'
FROM XSECT
WHERE [STE].[VENDOR] = XSECT.[BUMO]
AND XSECT.[GKU] = 0
AND [STE].[FCDATE] = NULL

[liulhj]

用到update语句中的from子句来解决。from子句中将包含update语句所涉及到的表的名称。所有这些标随后都将被连接在一起。
UPDATE [STE]
SET [FCDATE]='AA'
FROM [STE],XSECT
WHERE [STE].[VENDOR] = XSECT.[BUMO]
AND XSECT.[GKU] = 0
AND [STE].[FCDATE] IS NULL

[happy_0325]

UPDATE [STE]
SET [FCDATE]='AA'
FROM [STE],XSECT
WHERE [STE].[VENDOR] = XSECT.[BUMO]
AND XSECT.[GKU] = 0
AND [STE].[FCDATE] IS NULL

[antoversky]

UPDATE [STE]
SET [FCDATE]='AA'
WHERE [STE].[VENDOR] =(select XSECT.[BUMO] from xsect where
AND XSECT.[GKU] = 0)
AND [STE].[FCDATE] IS NULL

[wangdian178]

UPDATE A
SET A.[FCDATE]='AA'
FROM [STE] A,XSECT B
WHERE A.[VENDOR] = B.[BUMO]
AND B.[GKU] = 0
AND A.[FCDATE] IS NULL