Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Update with INNER JOIN

804312Aug 25 2011 — edited Aug 25 2011
Hi,

My update with inner join does not seem to work.

UPDATE RECAP R SET R.FLAVOR = (SELECT FN.FLAVOR FROM FLAVOR_NDC FN,RECAP R WHERE R.NDC11 = FN.NDC11)

When I write the above query, the inner query (SELECT FN.FLAVOR FROM FLAVOR_NDC FN,RECAP R WHERE R.NDC11 = FN.NDC11) returns multiple rows and this is a new syntax for me (as I was in Teradata and SQL server).

Can you please tell how can this query be written to have it working?

I am getting the below error message

SQL Error: ORA-01427: single-row subquery returns more than one row
01427. 00000 - "single-row subquery returns more than one row"
This post has been answered by Sayan Malakshinov. on Aug 25 2011
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 22 2011
Added on Aug 25 2011
5 comments
47,234 views