if i did my select like this

select MIDIRB,

IRBT.ID as IRBT_ID,

IRBT.IRBRATING as IRBT_IRBRATING,

ACRT.NEGWATCH as ACRT_NEGWATCH,

case when ACRT.NEGWATCH = 1 then (SELECT IRBT.IRBRATING FROM IRBT I WHERE I.ID = (IRBT.ID +1)) ELSE IRBT.IRBRATING end,

*

FROM ACRT

inner join IRBT

on IRBT.MOODYSRATE = ACRT.MOODYSRATE

do i just have to change select with update

if i do it that way i get errors