Re: Question on PL/SQL statement.

Thanks all!

So both of these codes do the same thing, right?

       EXEC SQL SELECT COUNT(*)
                INTO :rowcount
                FROM MY_LIST L1
                WHERE AND L1.batch_id = '1'
                AND L1.send_delete_ind in ('Y','N');


       EXEC SQL SELECT COUNT(*)
                INTO :rowcount
                FROM MY_LIST L1,
                     MY_LIST L2
                WHERE L1.key_no = L2.key_no
                AND L1.supply_code = L2.supply_code
                AND L1.batch_id = '1'
                AND L1.send_delete_ind = 'Y'
                AND L2.batch_id = '1'
                AND L2.send_delete_ind = 'N';

What is that guy uses the second method? Make the code more confusing... Received on Wed Jun 14 2006 - 15:54:08 CDT