PL/SQL (MOSC)

MOSC Banner

How to create a multi-table inter joined update query?

edited Jun 12, 2009 6:30AM in PL/SQL (MOSC) 7 commentsAnswered ✓
I have essentially the following query that requires an update query written.  This update query

would update TAB_A(s) COL1 & COL2 with values from TAB_B and TAB_C as follows:

SET :

TAB_A.COL1 = TAB_B.COL1

            TAB_A.COL2 = TAB_C.COL2

 

SELECT

    TAB_A.COL1,

    TAB_A.COL2

FROM

    TAB_A,

    TAB_B,

    TAB_C

 WHERE (   

     (TAB_C.COL3 = TAB_B.COL3)

        AND (TAB_B.COL1= TAB_A.COL1)

       )

 

How would an update query be constructed based on the above information?

Joins are important.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center