Help HELP

when executing a query, I recieve the error message below.

update t set(total_available)=
(select distinct
 count(L)
from tuv t, xyz x
where s.r = c.r (+)
group by s.r);

ERROR at line 2:
ORA-01427: single-row subquery returns more than one row

Anyone know how i should write this to get a result of total_available??

Book    Title         Cost    total_available
123     The Firm      23       5

with many thanks
Jonus Received on Thu Apr 08 1999 - 00:00:00 CDT