SELECT Ordprod.orderid, Ordsize.orderprodid,; SUM(Ordsize.ordered) AS totordered,; SUM(Ordsize.allocated) AS totallocated,; SUM(Ordsize.shipped) AS totshipped, .T. AS specialord; FROM ; Ordsize ; INNER JOIN ordprod ; ON Ordprod.orderprodid = Ordsize.orderprodid ; where OrdPro.orderid in (select orderid from OrderHead where SBO = .T.) GROUP BY Ordsize.orderprodid, Ordprod.orderid union all ; SELECT Ordprod.orderid, Ordsize.orderprodid,; SUM(Ordsize.ordered) AS totordered,; SUM(Ordsize.allocated) AS totallocated,; SUM(Ordsize.shipped) AS totshipped, .F. AS specialord; FROM ; Ordsize ; INNER JOIN ordprod ; ON Ordprod.orderprodid = Ordsize.orderprodid ; where OrdPro.orderid in (select orderid from OrderHead where SBO = .F.) GROUP BY Ordsize.orderprodid, Ordprod.orderid ORDER BY 2Or same with where EXISTS()
>SELECT Ordprod.orderid, Ordsize.orderprodid,; > SUM(Ordsize.ordered) AS totordered,; > SUM(Ordsize.allocated) AS totallocated,; > SUM(Ordsize.shipped) AS totshipped, Ordhead.sbo AS specialord; > FROM ; > Ordsize ; > INNER JOIN ordprod ; > ON Ordprod.orderprodid = Ordsize.orderprodid ; > INNER JOIN ordhead ; > ON Ordprod.orderid = Ordhead.orderid; > GROUP BY Ordsize.orderprodid, Ordprod.orderid, Ordhead.sbo; > ORDER BY Ordsize.orderprodid >>