I have loaded an sql statements into a text member and this does not work as RUNSQLSTM, yet this does work under STRSQL.
 
SELECT  IDDOCD AS INV_DATE, IDORD# AS ORD_NUM,        
IDORDT  AS ORD_TYPE, IDPRLC AS PROD_FAMILY,           
IDPR$C AS PRICE_CODE,IDCOM#,                          
MAX(IDPRT#) AS ITEM_REF,IARCC4 AS PROD_TYPE,          
IARC11 AS PROD_CLASS,IACMQC AS CUM_CODE,              
SUM(IDSHP#) AS NUM_UNITS,                             
SUM(IDSHP# * IDCSU$) AS TOT_COST,                     
SUM(IDSHP# * IDNTU$) AS TOT_SLS                       
FROM   OEIND94 INNER JOIN ICPRT1   ON IDPRT# = IAPRT# 
WHERE  IDCOM#='001' AND                               
IDDOCD >= 20130401    AND                             
IDDOCD <= 20130430  AND                               
IARCC4='FIN'                                          
GROUP BY IDDOCD, IDORD#,IDORDT,IDPRLC,IDPR$C,         
IDCOM#,IARCC4,IARC11,IACMQC ORDER BY  IDDOCD,IDORD#,  
IDORDT,IDPRLC,IDCOM#                                  

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.