text TO query TEXTMERGE noshow SELECT distinct(data.acc_code) as acc_code ,max(data.acc_name) as acc_name, sum(data.qty)as qty, sum(data.cr_amount)as c_ramount from ( SELECT acc_code ,acc_name, qty, cr_amount from crsalp where substring(acc_code,1,2)='32' and type='P' union all SELECT acc_code ,acc_name, qty, cr_amount from cashsalp where substring(acc_code,1,2)='31' and type='P' ) as data group by data.acc_code ENDTEXT