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 =...