title: Teradata Update Table from Select Statement
body: <p>Sorry if the title is unclear. Basically I'm trying to select certain records from multiple tables then update a certain column value for the returned records.</p>
  
  <p>T-SQL Implementation</p>
  
  <pre><code>    UPDATE 
          CUSTOMERS
      SET
          LIKES_US = 'Y'
      FROM
          RESTAURANT REST INNER JOIN CUSTOMERS CUST ON REST.LINK_ID = CUST.LINK_ID
          WHERE
          REST.REST_TYPE = 'Diner' AND CUST.LIKES_US IS NULL
  </code></pre>
  
  <p>Oracle</p>
  
  <pre><code>    UPDATE 
         (SELECT CUST.LIKES_US
          FROM CUSTOMERS CUST INNER JOIN RESTAURANT REST ON CUST.LINK_ID=REST.LINK_ID
          WHERE REST.REST_TYPE = 'Diner' AND CUST.LIKES_US IS NULL) NEW_CUST
      SET
          NEW_CUST.LIKES_US = 'Y';
  </code></pre>
  
  <p>I am tried doing the same thing in Teradata as I did in Oracle but I get the following error:</p>
  
  <pre><code>Executed as Single statement.  Failed [3707 : 42000] Syntax error, expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword between the 'UPDATE' keyword and '('. 
  Elapsed time = 00:00:00.003 
  
  STATEMENT 1: Unknown failed. 
  </code></pre>
  
  <p>I looked online for the solution but had no luck.</p>