How to add one column data to another table column using inner joins?

Question

0.00/5 (No votes)

See more:

there are two tables one is COPYCLAIMPRGNOTE and another one is COPYCLAIMPRGNOTE1, COPYCLAIMPRGNOTE contain only 2 columns one is claim_id and another one is NOTE_MEMO_CARETECH. and other table have many columns but NOTE_MEMO_CARETECH column is missing. I want to create NOTE_MEMO_CARETECH column in COPYCLAIMPRGNOTE1 with all the values which is in another table COPYCLAIMPRGNOTE.

please how to do that I am new in oracle so I don't know how to do it/

What I have tried:

SQL

INSERT INTO COPYCLAIMPRGNOTE1 (CLAIM_ID,NOTE_MEMO_CARETECH)  
    SELECT DISTINCT COPYCLAIMPRGNOTE1.CLAIM_ID,COPYCLAIMPRGNOTE1.NOTE_MEMO_CARETECH
    FROM COPYCLAIMPRGNOTE src 
    inner JOIN COPYCLAIMPRGNOTE1
    ON (COPYCLAIMPRGNOTE.CLAIM_ID=COPYCLAIMPRGNOTE1.CLAIM_ID)

SQL

insert into 
    COPYCLAIMPRGNOTE1 values (NOTE_MEMO_CARETECH)
INNER JOIN COPYCLAIMPRGNOTE ON
    COPYCLAIMPRGNOTE1.CLAIM_ID = COPYCLAIMPRGNOTE.CLAIM_ID
ORDER BY
    EVENT_ID DESC;

I tried this 2 queries to transfer data but its not working.

Posted 27-Jun-22 6:54am

Suraj Ingle

Updated 27-Jun-22 12:51pm

Maciej Los

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 12006214 · Answer 1 · 2022-06-27T12:51:00

Solution 1

Hi,

Insert will add new rows in your new table, it will not update the existing rows.
For this you will have to use update query as below

UPDATE T1 SET NOTE_MEMO_CARETECH=T2.NOTE_MEMO_CARETECH
FROM COPYCLAIMPRGNOTE1  T1
INNER JOIN COPYCLAIMPRGNOTE T2 ON T2.CLAIM_ID=T1.CLAIM_ID

Posted 27-Jun-22 12:51pm

Member 12006214