Re: SQL Delete Question

DELETE FROM DBPOPOR A
WHERE NOT EXISTS(
   Select *from DBPOPRL B Where A.DBPOR_COMPANY =
 B.DBPRL_COMPANY AND A.DBPOR_REC_NUMBER = B.DBPRL_REC_NUMBER
                                     )



----- Original Message ----- 
From: "Mike Wills" <>
To: "Midrange_RPG400_L" <rpg400-l@xxxxxxxxxxxx>
Sent: Friday, August 06, 2004 10:40 AM
Subject: SQL Delete Question


> I have this SQL statement:
>
> SELECT * FROM DBPOPOR EXCEPTION JOIN DBPOPRL ON DBPOR_COMPANY =
> DBPRL_COMPANY AND DBPOR_REC_NUMBER = DBPRL_REC_NUMBER ORDER BY
> DBPOR_COMPANY, DBPOR_REC_NUMBER
>
> I would like to delete all records that come up. But obiously I can't just
do:
> DELETE FROM DBPOPOR EXCEPTION JOIN DBPOPRL ON DBPOR_COMPANY =
> DBPRL_COMPANY AND DBPOR_REC_NUMBER = DBPRL_REC_NUMBER ORDER BY
> DBPOR_COMPANY, DBPOR_REC_NUMBER
>
> Is there a simple way to set this up or do I have to do this the hard way?
>
> -- 
> Mike Wills
> iSeries Programmer/Lawson Administrator
> koldark@xxxxxxxxx
> http://www.koldark.net
> Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>