Update with INNER JOIN
804312Aug 25 2011 — edited Aug 25 2011Hi,
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"