...pono,itemcode,itemname,orderqty
pqr is having fields slno,pono,itemname,receiveqty
now I am writing these codes to generate report :
sele xyz.*,pqr.receiveqty from xyz left outer join pqr;
on xyz.pono = pqr.pono where xyz.itemname = pqr.itemname;
into cursor abc
But in this the result is...