how does this delete work?

Hi,

Recently I came across this delete statement inside a package that I have to debug:

DELETE FROM
(

    SELECT 1
    FROM KUNDEN_SOLL ks, KUNDEN k
    WHERE ks.ksl_kun_id = k.kun_id
    ...
)

I must say the syntax is a little uncommon for me. What's the advantage of doing things that way instead of issuing a plain "delete from table where ..."?

thanks,
stephan Received on Mon Jul 09 2007 - 10:09:32 CDT