select 
a.div_amt_alloc	,
b.payment_dt	,
substr(c.stk_desc,1,38)	

from noth_stock_alloc a , nomh_announcement b , comh_counter c, comh_client d

where a.ann_num = b.ann_num
and substr(a.ann_num,5,1) = 'C'
and b.stk_cd = c.stk_cd
and a.client_cd = d.REM_cd 
and rtrim(d.rem_cd) = 'ABC'
and B.payment_dt between to_date('01/08/2009}','dd/mm/yyyy') and to_date('31/08/2009',''dd/mm/yyyy'')'
order by b.payment_dt;

those query will show 1 rem_cd = 4 client_cd(every client code = 1page) and that single client_cd contain 1 stk_cd.
how can i show the result 1 rem_cd = 1 client_cd with 1 stk_cd in 1page?
example :
[page1]
rem code = ABC
client code = XYZ
stk code = 1
2
3

[page2]
rem code = ABC
client code = XXX
stk code = 1
2
3

the problem is stk code = 1 belong to XYZ client only and stk cd = 2 for XXX client code but it keep repeating on another page and so on..:(
really2 need help here..:-/

You need to use GROUP BY clause in your SQL.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.