I am using ORACLE and this version does not have INNER JOIN in its vocabulary. I have tried shifting the WHERE statement as you earlier suggested. I am not getting the multiple row error, but now I get an error where it does not recognize "CD.Label_Name" in line 11. I'm inexperienced - I don't imagine this is that unique a problem - there must be a solution.

No it doesn't need to group, if it didn't work that was for different reason. Can you please let me know which error is returned when you run query i suggested?<br /><br />No problem with asking for help here as far as I am concerned, but it is better to mention that you are using Oracle. This way we won't offer t-sql specific solutions and some of us know a litle bit about oracle, so we are able to work inside its restrictions. <img src='/community/emoticons/emotion-1.gif' alt='' />

What about adding ';' at the end of inside select statement:<br /><br /><pre>Update Label2<br />Set Label2.Revenues = (Select SUM(Sdollars)<br /> From CD_Sales, CD<br /> Where Label2.Label_Name = CD.Label_Name<br /> AND CD.CD_Id = CD_Sales.CD_Id<img src='/community/emoticons/emotion-5.gif' alt='' /><br />Where Label2.Label_Name = CD.Label_Name;</pre><br /><br />I haven't work with Oracle for a while. I work with Oracle 9 a year ago and Oracle 8 3 years ago. I can miss the syntax, but if I remember well correlated queries are supported with this version. So hope this syntax works, but not quite sure. <br />

Actually you can have where label2.Label_name = CD.Label_name because cd is not visible in update statetment it is visible only inside correlated query, you must put constant of variable in where part of update:

But that is the problem. I need the "variable" to be a list of names found in either the table "Label2" or in the Table "CD" or in the query that created the SUM(Sdollars). THey all have the same number of rows with the same distinct Label_Names.