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

    insert "update procedures" query by inner join.

    Prashanthi Kairuppala Novice

      Hello,

       

      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 - >

       

      SELECT

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

        FROM

        (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,

      Prashanthi.