Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.41K
|
[code]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;[/code] those query will show … 
|