4 Replies Latest reply on Jul 13, 2015 1:04 PM by Prashanthi Kairuppala

    insert "update procedures" query by inner join.

    Prashanthi Kairuppala Novice



      I am trying to select and insert in to multiple tables which has one common column.

      I have been able to select from tables by inner joins. how do I right the same query in update procedures by inner joins??


      sample select query - >



        a.ID, name, b.address, b.phoneno, c.address AS address_1, c.phoneno AS phoneno_1


        (OracleConn.table1 AS a INNER JOIN OracleConn.table2 AS b ON a.ID = b.ID) INNER JOIN OracleConn.table3 AS c ON a.ID = c.ID


      Any help much appreciated.

      Thanks in advance,