Yes, you can. You have it coded correctly by just using the AND.
Here is a sample of my code:
This is in a source member as I try to use RUNSQLSTM.
That way I can make modifications without having to recompile programs.
INSERT INTO CUBRANCH
(CUNO, ORGBRN, ORGNAM, BRNAME, USRPRF)
SELECT ‘1379’, t.ORGBRN, t.ORGNAM, t.BRNAME, ‘New Record’
FROM cuBRaNCHt t Exception Join cubranch p
on t.cuno = p.cuno
and t.oRGBRN = p.ORGBRN;