MS Access subquery problem

I have two tables, and old one and a new one. The new one was populated by someone else, but he neglected to include a needed column. I want to pull the data from the old table into the new one, so I tried this:

UPDATE divisions
SET div_group = 'Realty Specialist'
WHERE div_id IN (
	SELECT div_id, div_group
	FROM divisions_old
	WHERE div_group = 'Realty Specialist'
	)

I don’t get why it won’t work. I get this rather odd error message:

You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query’s FROM clause. Revise the SELECT statement of the subquery to request only one field.

What am I doing wrong?


UPDATE divisions
SET div_group = 'Realty Specialist'
WHERE div_id IN (
    SELECT div_id
    FROM divisions_old
    WHERE div_group = 'Realty Specialist'
    )

try that. you were returning div_group also

That was it! For some reason I was thinking that I had to include it in the SELECT in order to have it in the WHERE clause. :injured:

Still learning!