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