Should look like this:
select idord#, sum(idshp# * idntu$) from astdta.oeind2 WHERE idprt# not
like 'frt%' AND iddocd > 20150930
group by idord#

This thread ...


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

This mailing list archive is Copyright 1997-2020 by 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].