Hi
Experts
How to merge and data retrieve Multiple procedure
Procedure 1
select shareno,date as Dat,
Recptamt,Payamt,openingbalance as obrecpt,0 as obpay ,
0 as opnbal, 0 as cb1,0 as cb2 from `dbbank`.`sharledg`
where shareno=_selectid and date between '01-06-2015' and '18-08-2015' group by date ;
Procedure 2
select shareno,date,0,0,0,0,openingbalance as opnbal,0 as cb1,0 as cb2 from `dbbank`.`sharledg`
where shareno=_selectid and date < '01-06-2015' order by date desc limit 1;
Mark as Answer if its helpful to you
Kumaraspcode2009@gmail.com