Re: Query question

In article <1994Apr21.181129.15056_at_arco.com>, Gary Meyers <dbsgrm_at_arco.com> wrote:
>
>update temp_results tr
>set (mean,stdev) =
>(select avg(temp),stddev(temp)
>from station s,temp t
> where s.station_id = t.station_id
>and s.station_id in (select station_id from station)
>and yr between '1976' and '1987'
>group by s.station_id)
>where tr.station_id in (select station_id from station)
>
>I know the select avg(temp),stddev(temp) part works, but I am, of course, getting a
>
>"ORA-01427: single-row subquery returns more than one row" error.
>
>Thanks for the help, folks.
>--
>Gary Meyers : Usual disclaimer here
>gary.meyers_at_Edm.Arco.COM : My opinions, etc. etc.
>
>

TRY: update temp_results tr
set (mean,stdev) =
(select avg(temp),stddev(temp)
from station s,temp t
where s.station_id = t.station_id
and s.station_id = tr.station_id
and yr between '1976' and '1987'
) Received on Fri Apr 22 1994 - 21:24:45 CEST