>Table1: > >Custno Sales >ABCD 40000 >XYZS 20000 > >Table2: > >Custno Sales >XYZS 100 >YYYY 7000 >>
>Cursor1: > >Custno TotalSales >ABCD 40000 >XYZS 20100 >YYYY 7000 >>
select NVL(C1.CustNo, C2.CustNo) as CustNo, NVL(C1.Sales,0) + NVL(C2.Sales,0) as TotalSales ; from cursor1 C1 FULL JOIN cursor2 C2 ON C1.CustNo = C2.CustNoCan you upgrade to VFP9? VFP5 is so ancient, that it's hard to predict what is there and what is not.