1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| spool c:\gros_client_devise.xls
SET TRIMSPOOL ON
SET LINESIZE 500
SET HEAD ON
SET FEEDBACK ON
--SET VERIFY OFF
select DISTINCT t2.m_custno, t2.m_glno, t1.cust_name, t2.m_bal, t2.m_cur
from cust t1, sbkmaster t2
where t2.m_glno in (251111,251120, 251121, 251122, 251130, 251131, 251132, 251140, 251141, 251150,
251151,251152, 251160, 251161, 251162, 251170, 251171, 251172, 251180, 251181, 251182, 251190, 251191, 253110)
and t2.m_cur in ('USD', 'EUR')
and t2.m_bal >= 50000
and t1.cust_code = t2.m_custno;
spool off
exit |
Partager