merging sql scripts
hi,
i have a 3 scripts which have an output of different third columns, i do wish to merge them for another purpose...
script 1:
select p.name, cl.name, count(*) "OR_COUNT"
from iteneraries i,receipts r,customers p,customers c,collectors cl
where i.pcode=p.code
and i.pcode = p.pcode
and i.bank_provider = p.bank_provider
and i.cust_code=c.code
and i.pcode = c.pcode
and i.bank_provider = c.bank_provider
and i.code=r.it_no
and i.pcode=r.pcode
and i.coll_code=cl.code
and (i.status is null or i.status='S')
script 1:
select p.name, cl.name, count(*) "OR_COUNT"
from iteneraries i,receipts r,customers p,customers c,collectors cl
where i.pcode=p.code
and i.pcode = p.pcode
and i.bank_provider = p.bank_provider
and i.cust_code=c.code
and i.pcode = c.pcode
and i.bank_provider = c.bank_provider
and i.code=r.it_no
and i.pcode=r.pcode
and i.coll_code=cl.code
and (i.status is null or i.status='S')
0