Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Query help
this is the results I get running my query
SELECT e.shipdate,a.acctnum,a.custnum as parentnum,b.Listable,b.ListDisplayCount, a.jobnum,a.acctnum,b.ShowOne,b.custnum,c.proddesc as description From co_acctdtl a,v_custprodinfo b,v_products c,v_job e Where a.custnum = '67500Z' and a.prodnum = b.custnum and a.acctnum = '1263235' and
a.custnum = b.parentnum and c.custnum = a.custnum and c.prodnum = a.prodnum and b.docviewenabled = 'Y' AND a.custnum = e.custnum AND a.jobnum = e.jobnum AND b.Listable = 'Y' AND rtrim(a.redojob) is null
SHIPDATE|ACCTNUM|PARENTNUM|LISTABLE|LISTDISPLAYCOUNT|JOBNUM|ACCTNUM|SHOWONE|CUSTNUM|DESCRIPTION
2001-10-22 07:50:00|1263235|67500Z|Y|2|078017|1263235|Y|675002|MONTHLY
BILLING STATEMENTS
2001-09-21 19:42:00|1263235|67500Z|Y|2|074436|1263235|Y|675003|ESCROW
ANALYSIS STATEMENTS
2001-09-25 10:50:00|1263235|67500Z|Y|2|074881|1263235|Y|675002|MONTHLY
BILLING STATEMENTS
2001-09-25 14:16:00|1263235|67500Z|Y|2|075094|1263235|Y|675002|MONTHLY
BILLING STATEMENTS
The problem I have is this is not what I want I only want to pull the
number of lines that have been entered in the LISTDISPLAYCOUNT field,
basically
I want to be able to list the lines per custnum based on that field.
Any way of doings this easily. I really need to get it all with one
query, due to the way we are using it as a recordset in our program.
any ideas???? Received on Fri Oct 26 2001 - 14:32:00 CDT