Incorrect syntax near the keyword 'FROM'

[wallic]

Hello,

This is my first post and I am a beginner with SQL code. The code below is supposed to update a new table (loctable) with a calculated value based on the original table (hra_data). There are 3 possibilities in the hra_data table that will cause the loctable to be updated with the calculated value. After playing with it, I thought it was in the correct format but I keep getting an "Incorrect syntax..." error. Any guidence would be greatly appreciated! Since I'm a beginner, I assume its a simple issue. :)

Thanks!

update loctable 
    set loctable.wscombinedded = ([HRA_DATA.DPHURRICANEPCT]*[HRA_DATA.COVERAGEA]/100)
        (select (([HRA_DATA.DPHURRICANEPCT]*[HRA_DATA.COVERAGEA])/100)
            from hra_data
            where (hra_data.policy=loctable.accntnum and hra_data.location=loctable.locnum
                and        (HRA_DATA.DPHURRICANEPCT<500 and HRA_DATA.ratcls='cr') 
                    OR (HRA_DATA.DPHURRICANEPCT<500 AND HRA_DATA.RATCLS='dp' AND HRA_DATA.RATCOL='1')
                    OR (HRA_DATA.DPHURRICANEPCT<500 AND HRA_DATA.RATCLS='dp' AND HRA_DATA.RATCOL='3')
                    OR (HRA_DATA.DPHURRICANEPCT<500 AND HRA_DATA.RATCLS='dp' AND HRA_DATA.RATCOL='4')    )
                )
        FROM LOCTABLE, HRA_DATA    
 
Server: Msg 156, Level 15, State 1, Line 11
Incorrect syntax near the keyword 'FROM'.
 

[almaz]

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

[wallic]

Thank you.. but when I try this I get an error:

Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'HRA_DATA.DPHURRICANEPCT'.
Server: Msg 207, Level 16, State 1, Line 1
Invalid column name 'HRA_DATA.COVERAGEA'.
Server: Msg 207, Level 16, State 1, Line 1
Invalid column name 'DPHURRICANEPCT'.

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

[wallic]

Thanks! It does work... I had a column name entered wrong the 2nd time.