The UPDATE will merge of the numerical examples how to use?-CodePudding

SELECT * FROM BFCRM8. HYK_MDJF WHERE HYID=100424927;

how to get the list of WCLJF numerical is added to WCLJF MDID for 4?

I do before, but the error, tip end of the SQL command not correct, but it can perform in SYBASE, not in ORACLE,
The UPDATE BFCRM8. HYK_MDJF SET aleem walji CLJF=aleem walji CLJF + B.W CLJF
The FROM BFCRM8. HYK_MDJF A, BFCRM8. HYK_MDJF B
WHERE A.H YID=B.H YID
AND A.H YID=100424927 AND arjun DID=1;

See who can help me to tone down the UPDATE statement, thank you!!!!!

CodePudding user response:

How to get the list of WCLJF numerical is added to WCLJF MDID for 4?

CodePudding user response:

The UPDATE BFCRM8. HYK_MDJF A SET aleem walji CLJF=(SELECT SUM (WCLJF) FROM BFCRM8. HYK_MDJF B
WHERE HYID=100424927 AND
A.H YID=B.H YID)
WHERE arjun DID=4 AND HYID=100424927;

Refer to the opinions of others, the SQL statement, feasible!!!!!!

CodePudding user response:

 UPDATE BFCRM8. HYK_MDJF A SET aleem walji CLJF=aleem walji CLJF + B.W CLJF 
The FROM BFCRM8. HYK_MDJF B 
WHERE A.H YID=B.H YID 
AND A.H YID=100424927 AND arjun DID=1;