sql scripts help
hi,
i have this script:
select r.cust_name,r.code,p.ded_desc4,p.ded_amt1,p.ref_no,r.remarks
from receipts r,payments p
where r.code=p.rct_code
and r.pcode=p.pcode
and r.pcode='principal'
and r.bank_provider='CTB'
and to_char(r.date_issued,'yyyymmdd')='date'
which likelyhave an output:
cust_name code ded_desc4 ded_amt1 ref_no remarks
client1 1234 rtv456111 1456 1500000 test
client1 1235 rtv456221 1451 1600000 test
client2 1245 dmi12212 1245 2100000 test
now i do wish in cust_name column not to repeat the data since it has the same value
which the new output will be:
i have this script:
select r.cust_name,r.code,p.ded_desc4,p.ded_amt1,p.ref_no,r.remarks
from receipts r,payments p
where r.code=p.rct_code
and r.pcode=p.pcode
and r.pcode='principal'
and r.bank_provider='CTB'
and to_char(r.date_issued,'yyyymmdd')='date'
which likelyhave an output:
cust_name code ded_desc4 ded_amt1 ref_no remarks
client1 1234 rtv456111 1456 1500000 test
client1 1235 rtv456221 1451 1600000 test
client2 1245 dmi12212 1245 2100000 test
now i do wish in cust_name column not to repeat the data since it has the same value
which the new output will be:
0