SQL - Delete with multiple tables

["John Candidi" <jacandidi@xxxxxxxxxxxxxxxxxxxx>]

I have the folowing SQL query:

SELECT rcd4.* FROM rugd80dat.rcd4cpp AS rcd4, rugd80dat.rcd3cpp AS rcd3
WHERE rcd4.d4bznb = rcd3.d3bznb AND 
    rcd4.d4bwrtdt = rcd3.d3bwrtdt AND 
    (rcd3.d3polsym BETWEEN '000' AND '999') AND 
    rcd3.d3e3st = 'P'

I want to change this to be able to delete the result set, but having problems 
with the SQL not wanting to run a delete with multiple tables in the list.

I am using the iSeries Navigator RUN SQL dialog to try to do this.