I am having 2 tables name xyz and pqr
xyz is having fields 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 omiting all the records of xyz which is not having receiving in pqr.
I want to show all the records of xyz.
How is it possible...
Please help
Thanks and regards
xyz is having fields 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 omiting all the records of xyz which is not having receiving in pqr.
I want to show all the records of xyz.
How is it possible...
Please help
Thanks and regards