Question on PL/SQL statement.

Hi,

I inherit the following PL/SQL statement:

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

I don't understand why it needs L1 and L2. Is the above code the same as the following:

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

Thanks in advance!
feilip Received on Tue Jun 13 2006 - 21:36:40 CDT