|
db
Are you willing to print the QRYDFN and post it here, or send it to me offlist?
Vern
O.k., I've got this working now with:
SELECT ALL SUBSTR(T03.SCDSSS,1,6) AS GLACCT, T01.INVNCV, T01.CUNOCV, T04.CUSNM, T01.IVDTCV, T02.LISQVS, T03.SCDSSS, (T03.SCAMSS) FROM AMFLIB/CUSINVL0 T01 inner join AMFLIB/CIVSPCL0 T02 on ( T01.INVNCV = T02.INVNVS AND T01.INSQCV = T02.INSQVS ) inner join AMFLIB/CUSMAS T04 on ( T01.CONOCV = T04.COMNO AND T01.CUNOCV = T04.CUSNO ) inner join AMFLIB/COSSPCL0 T03 on ( T02.ORDRVS = T03.ORDRSS AND T02.SHSQVS = T03.SHSQSS AND T02.SCSQVS = T03.SCSQSS ) Where T01.CONOCV = 01 AND T01.ICDTCV BETWEEN 1040701 AND 1040731 AND T03.SCCDSS = '2' ORDER BY GLACCT ASC, T01.INVNCV ASC
-snip-
Oh, and I would ask again, why did RTVQMQRY surround the T03.SCAMSS field in the SELECT in parentheses?
-snip-
As an Amazon Associate we earn from qualifying purchases.
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.