0

I've got a SELECT statement built that properly identifies records I wish to delete. My syinvolv table is a linking table that associates two primary keys (one from nmmain and prmain in my example)

SELECT count(*)
    FROM syinvolv 
    LEFT JOIN prmain ON syinvolv.relrec = prmain."number" 
    LEFT JOIN nmmain ON syinvolv.rec = nmmain."number" 
    WHERE prmain.ownerid != syinvolv.rec AND prmain.ownerid != nmmain.aka;

However, isql appears to be unable to handle the syntax when switching to DELETE

DELETE
    FROM syinvolv 
    LEFT JOIN prmain ON syinvolv.relrec = prmain."number" 
    LEFT JOIN nmmain ON syinvolv.rec = nmmain."number" 
    WHERE prmain.ownerid != syinvolv.rec AND prmain.ownerid != nmmain.aka;

I tried DELETE FROM syinvolv, DELETE syinvolv FROM syinvolv, I finally tried chatGPT assistance which suggested a NOT EXIST statement but that altered my data set so the SELECTED records were incorrect. Any ideas?

0 Answers0