Open PO SQL

select pmm01 PONo,pmn02 POSeq,pmm04 PODate,pmm09 VenderCode,pmc03 VendorST
,pmn04 Item,ima02 ItemName,ima021 ItemSpec,pmn20 POQty,pmn07 Unit,pmm22 Currency,pmm42 CurrRate
,pmn31 UnitPrice,pmn50 RcvQty,pmn55 ReturnQty
,pmn20-pmn50+pmn55 OpenQty
from pmm_file,pmn_file,pmc_file,ima_file
where pmm01=pmn01 and pmm09=pmc01 and pmn04=ima01
and pmn20-pmn50+pmn55>0
and pmm25 in('0','1','2') and pmn16 in('0','1','2')

 

 

select first 10 * from pmc_file