Yes - just found this out as well

So now I'm trying to work with this:

UPDATE FGMULTI

JOIN

arinvt ar ON

LEFT OUTER JOIN

fgmulti.arinvt_id = ar.id

SET NON_CONFORM_ALLOCATABLE = 'Y'

WHERE

IN_Date = CurrentDate

AND

ar.Class LIKE 'CP%'

OR

ar.Class LIKE 'FG%'

OR

ar.Class LIKE 'IN%'

OR

ar.Class LIKE 'LA%'

OR

ar.Class LIKE 'PK%'