hi

out of interest is it possible to do it this way

update ACRT set MIDIRB = min(IRBT2.IRBRATING)

from ACRT,IRBT,IRBT2 where ACRT.MIDIRB = IRBT.IRBRATING

and IRBT2.IRBRATING > IRBT.IRBRATING

and if so what do i have to do to get this error out of it

Msg 208, Level 16, State 1, Line 1

Invalid object name 'IRBT2'.

IRBT2 is a table in database