local ldfirst,ldend,lcfishcode1,lcfischcode2 ldfirst=thisform.txtd1.value ldend=thisform.txtd2.value lcfischcode1=[001] && sales fische type lcfischcode2=[002] && sales fische type select sum(quantity)*sum(price)/sum(quantity) as navgpriceS where fischetype= m.lcfishcode1 and ; between(ldate,m.ldfirst,m.ldend) into cursor CrsSales select sum(quantity)*sum(price)/sum(quantity) as navgpriceB where fischetype= m.lcfishcode2 and ; between(ldate,m.ldfirst,m.ldend) into cursor CrsBuyingsand then i am joining above cursors with one cursor via left join,