help in script?
hi all,
i have two sets of scripts which i run regularly, now i want them to join together since they only differ on the third column of my output, problem is i dont get the exact figures as expected.
here's the script w/ corresponding output:
script:
select substr(c.name,1,50)PRINCIPAL,i.coll_date "IT_DATE",count(i.code) "TRIPS_ITD"
from sbis.iteneraries i, sbis.customers c, sbis.customers k
where to_char(i.coll_date,'YYYYMMDD') = 'date'
and i.pcode=c.code
and c.code=c.pcode
and i.cust_code=k.code
and i.bank_provider='bnk'
i have two sets of scripts which i run regularly, now i want them to join together since they only differ on the third column of my output, problem is i dont get the exact figures as expected.
here's the script w/ corresponding output:
script:
select substr(c.name,1,50)PRINCIPAL,i.coll_date "IT_DATE",count(i.code) "TRIPS_ITD"
from sbis.iteneraries i, sbis.customers c, sbis.customers k
where to_char(i.coll_date,'YYYYMMDD') = 'date'
and i.pcode=c.code
and c.code=c.pcode
and i.cust_code=k.code
and i.bank_provider='bnk'
0