On Tue, 22 Apr 2008, Leandro Casadei wrote:
> Hi, I need to update a field from a table based in a count.
>
> This is the query:
>
>
> update shops
> set itemsqty =
> (
> select count(*)
> from items i1
> join shops s1 on i1.shopid = s1.shopid
> where s1.shopid = s0.shopid
> )
> from shops s0
I think you'll actually want something simpler. The following might do
what you want.
update shops
set itemsqty =
(
select count(*)
from items i1
where i1.shopid = shops.shopid
)