Is this type of query supported ? Struggling to make this work.
SELECT ITM.item ,ITM.ionhand ,ILO.lonhand ,ILO.orderpt ,ILO.lonordr ,DT.MatAllocated ,DT.MinReqDate
FROM (("D:\data\icitem") ITM
LEFT JOIN "D:\data\iciloc" ILO ON ITM.item = ILO.item )
INNER JOIN
SELECT WOH.wono ,WOD.partno ,SUM(WOD.qtyaloc) AS MatAllocated ,MIN(WOH.reqdte) AS MinReqDate
FROM (("D:\data\ppwohd") WOH LEFT JOIN "D:\data\ppwodt" WOD ON WOH.wono = WOD.wono )
WHERE 1 = 2
GROUP BY WOD.partno DT
ON ITM.item = WOD.partno
WHERE 3=4
|
For sercurity limitation, you should use "jdbc:dbf:d:\", then
SELECT ITM.item ,ITM.ionhand ,ILO.lonhand ,ILO.orderpt ,ILO.lonordr ,DT.MatAllocated ,DT.MinReqDate FROM ("data\icitem" ITM LEFT JOIN "data\iciloc" ILO ON ITM.item = ILO.item ) INNER JOIN (SELECT WOH.wono ,WOD.partno ,SUM(WOD.qtyaloc) AS MatAllocated ,MIN(WOH.reqdte) AS MinReqDate FROM "data\ppwohd" WOH LEFT JOIN "data\ppwodt" WOD ON WOH.wono = WOD.wono WHERE 1 = 2 GROUP BY WOD.partno) ON ITM.item = WOD.partno WHERE 3=4
|