Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Copy result of a join into another table

WhyNotOct 29 2014 — edited Oct 29 2014

Hi all,

I want to copy the join of two tables into another table. I tried the following approach but I have error

       insert into new_copy  values (ID,name,na_name)  

       SELECT

         name

        FROM

          country u

        INNER JOIN

          (

            SELECT

             na_name

            FROM

              country2 st

          )

          s

        ON

          u.id = s.ID;

This post has been answered by JonWat on Oct 29 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2014
Added on Oct 29 2014
12 comments
466 views