Re: more than one row returned by a subquery used as an

CSN wrote:
> I'm trying to get this query to work:
>
> update sectors set companies =(select companies from
> industries where sector_id =sectors.id);

Try these instead:

update sectors
set companies = industries.companies
from industries
where industries.sector_id =sectors.id;

update industries
set companies = count(companies.id)
from companies
where industry_id = industries.id;

--
Alban Hertroys