Update query from Select

[wallic]

I am using the code below to update my "loctable". When I run just the select portion of the query, it returns the rows that are specified... but when I run the update query it says all "row(s) affected" rather than just the ones from the select query... plus not all of the rows are updated... any ideas?

note: loctable.locnum came from hra_data.location as well as loctable.accntnum came from hra_data.policy

update loctable 
set loctable.wscombinedded = (
    select HRA_DATA.DEDHURRICANEPCT*HRA_DATA.COVERAGEA/100
    from hra_data
    where hra_data.policy=loctable.accntnum and hra_data.location=loctable.locnum
    and HRA_DATA.DEDHURRICANEPCT<500 and 
        (HRA_DATA.ratcls='cr' OR ( HRA_DATA.RATCLS='dp' AND HRA_DATA.RATCOL in (1, 3, 4)))
)
 

[scripto]

update loctable
set wscombinedded = (
select HRA_DATA.DEDHURRICANEPCT*HRA_DATA.COVERAGEA/100
from hra_data inner join loctable on
( hra_data.policy=loctable.accntnum and hra_data.location=loctable.locnum)
where HRA_DATA.DEDHURRICANEPCT<500 and
(HRA_DATA.ratcls='cr' OR ( HRA_DATA.RATCLS='dp' AND HRA_DATA.RATCOL in (1, 3, 4))) )
where accntnum = 999 and locnum = 999

only add the last "where" clause if you want to update only a specific row - other wise leave it out to update the entire table.