How do you use inner joins on a delete statement using oracle
Posted on 2011-03-09
I am getting this error when I try to compile the following sql statements in ORACLE. It is telling me that the statement is not ended correctly. It is highlighting the first inner join. Can someone tell me what is wrong here
DELETE FROM batch_payment_schedule bps
INNER JOIN w_batch_pledge_entry wbpe ON wbpe.bpe_batch_number = bps.batch_number
AND wbpe.bpe_number = bps.bpe_number
INNER JOIN batch_pledge_entry bpe ON bpe.bpe_batch_number = wbpe.bpe_batch_number
AND wbpe.bpe_number = bpe.bpe_number
WHERE (wbpe.bpe_payment_frequency = 'O'
AND bpe.bpe_payment_frequency <> 'O'
AND bps.bpe_schedule_status = 'U'
AND wbpe.xoption IN (adv_declarations.c_modify));