Hello

I'd like to update the values of av.score_no to 0 where the value of
pe.avail_flag='Y'
and pe.person_id=av.person_id

Could some kind person provide a tip?

Thanks.


update score av
set av.score_no=0.0
from score av,
(
select
pe.*,
av.*
from score av
join
people pe
on av.person_id=pe.person_id
where pe.avail_flag='Y'
) b
where b.person_id=av.person_id

On 2012-01-18 00:20, gimme_this_gimme_that (AT) yahoo (DOT) com wrote:
something like:

update score av
set av.score_no=0.0
where exists (
select 1
from people pe
where av.person_id = pe.person_id
and pe.avail_flag='Y'
);

/Lennart

Yay! That worked. Thanks Lennart.