select count(op140m.pfpn) from prdat/op140m join cgoderi/op140mup ON op140m.PFCORP = op140mup.PFCORP and op140m.PFSTCN = op140mup.PFSTCN and op140m.PFPN = op140mup.PFPN and op140m.PFSTCN = p140mup.PFSTCN and op140m.PFEFDT = op140mup.PFEFDT
I have 1 table op140mup with 8088 records and op140m with over 400000 records. I want to update 1 field in op140m but only for all based on the join with op140mup (5 join fields). The count in the above statement is correct but what would be the syntax if I want to use update in stead of select? Can I use update in combination with a join?