3 Replies Latest reply on Jul 29, 2012 9:19 PM by Robin Dong

    How to write the update script

    Robin Dong Newbie

      I need a update script to update A column in Table A to B column in Table B, below is the update script which can run in MS SQL SERVER

       

      update a set a.COL_A = b.COL_B

         from TABLE_A a, TABLE_B b

      where a.ID = b.ID

       

      How can I write the script in Teiid?