Select语句中的Teradata更新表

您是否使用Teradata尝试了以下语法：

UPDATe CUSTOMERS C1  FROM (SELECt C2.link_ID          FROM CUSTOMERS C2         INNER JOIN RESTAURANTS R2 ON C2.link_ID = R2.link_ID        WHERe R2.REST_TYPE = 'DINER'          AND C2.LIKES_US IS NULL) D1   SET LIKES_US = 'Y' WHERe C1.link_ID = C2.link_ID