I'm trying to delete unmatched records from file A based on file B. The files are matched by ListNo.
Code: DELETE FROM DVMURRAY/INSRP100 WHERE SHListNo = ALL ( SELECT SHListNo FROM DVMURRAY/INSRP100 Left Outer Join DVMURRAY/INSRP200 on SHListNo = SDListNo WHERE SDListNo is Null ) Row not found for DELETE.
The select statement work file, returning a list of unmatched records,
Not being a SQL guru, I need some help. This is for an RPGSQL program.
November 24, 2010 5:31 PM
November 24, 2010 8:34 PM