how to not diplay all the negative values in my output
hi all,
i am newbie in programming now i do have a script to which have an output specified.
now i do want to not include all the negative values in my references amount,
have been trying to manipulate but unable to display the required fields,
heres the script that i am trying to work things out.
best wishes to everyone.
select distinct r.date_issued, r.cust_name, r.code, c.chk_no,
decode(c.item_no,1,p.ref_no, null)"REF_NO",
decode(c.item_no,1,p.ref_amt,null)"REF_AMT"
from sbis.receipts r, sbis.checks c, sbis.payments p
i am newbie in programming now i do have a script to which have an output specified.
now i do want to not include all the negative values in my references amount,
have been trying to manipulate but unable to display the required fields,
heres the script that i am trying to work things out.
best wishes to everyone.
select distinct r.date_issued, r.cust_name, r.code, c.chk_no,
decode(c.item_no,1,p.ref_no, null)"REF_NO",
decode(c.item_no,1,p.ref_amt,null)"REF_AMT"
from sbis.receipts r, sbis.checks c, sbis.payments p
0