1.txt

This is example for E-Market to use sequential file instead of database.

SELECT SN FROM edmi.viewmetercontact WHERE SN in (Select SN FROM tblslac WHERE recdate = to_date('13-05-2009','dd-mm-yyyy') AND errorsource like '%96%') and recdate = to_date('13-05-2009','dd-mm-yyyy') Group by SN Order by SN