0
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..:-/

Edited by arthemyth: n/a

2
Contributors
1
Reply
2
Views
6 Years
Discussion Span
Last Post by debasisdas
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.