Re: Question on PL/SQL statement.

Thanks for your insight. I appreciate that.

How about this:

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

Would it be the same as following? I just don't understand why it has L1 and L2. What are they for? Thanks.

       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';