× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



On Mon, Dec 12, 2016 at 3:19 PM, (WalzCraft) Jerry Forss <
JForss@xxxxxxxxxxxxx> wrote:


I have 2 files, Order Header and Order detail, both keyed with Cust# and
Order#.

What I want is a single row per Cust#, Order# with the sum of Quantity
from detail file.





Try a common table expression :



SqlSel = '

with od_ttl_qty as
( select OdCustNo, OdOrderno, Sum(OdQty) As Pieces
Group By OhCustNo, OhOrderNo )

Select OhCustNo, +
OhOrderNo, +
OhType, +
OhDSOOrd, +
OhShipDt1, +
OhInvoice1, +
OhAmount1, +
OhDiscnt1, +
OhPaidDt1, +
OhPaidDay1, +
OhEOL1, +
OhEOLDays1, +

od.Pieces +

From CusOrdHdS1 OH +

Inner Join od_ttl_qty OD On OdCustNo = OhCustNo And +
OdOrderno = OhOrderNo +

Where OhCustNo = ' + %EditC(CustNo : 'X') + ' And ' +
'OhShipDt1 >= ' + %Char(StartDateISO) + ' And ' +
'OhShipDt1 <= ' + %Char(EndDateISO) + ' ' +

'Order By OhShipDt1';



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.