0

This is the code I am trying to run, which hopefully makes sense

UPDATE OPMAT a 
INNER JOIN ARINVT b
ON a.ARINVT_ID = b.ID
SET a.EXCLUDE_REJECTS_BACKFLUSH = 'Y'
WHERE b.CLASS = 'PK'

In English ...Update the field EXCLUDE_REJECTS_BACKFLUSH from table OPMAT where CLASS from table ARINVT = 'PK' joined on OPMAT.ARINVT_ID = ARINVT.ID

I can do the is MS SQL but cant figure it out in Oracle. Currently getting the error missing SET keyword.

Barbaros Özhan
  • 59,113
  • 10
  • 31
  • 55
Rob
  • 1
  • You might try; UPDATE OPMAT SET EXCLUDE_REJECTS_BACKFLUSH = 'Y' where 0 < (select count(*) from ARINVT where ID = ARINVT_ID and EXCLUDE_REJECTS_BACKFLUSH = 'Y'); – Paul Stearns Apr 07 '22 at 21:13
  • How does this only do records where ARINVT_ID.CLASS = 'PK' ? – Rob Jun 23 '22 at 17:33

0 Answers0