10 Replies Latest reply: Feb 28, 2014 9:15 PM by rp0428 RSS

    Updating a table

      Hi all,




      I am really confused when updating a table. I can not understand the logic how to do it


      Right now I want to update T1  (a1, b1, c1, d1 )  with  T2 (b2, c2, d2)

      As in:


      Update T1

      set a1='AIX'

      where b1=b2 and

      c1 between c2 and d2

      and d1='Oracle';



      Please help....


      Thanks Pk