>select 1 as dummy, * from tmpbal into cursor tmp ;
>union all select -1 as dummy, * from pc ;
>union all select 1 as dummy, * from pay
>
>select client_num,client_src,SUM(dummy*amount) as balance ;
>from tmp ;
>group by 1,2

Ok, I wasn't reading it right... That group by takes care of things...

Thanks,

-Michelle