home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 6 / developer source - volume 6.iso / parad / may95 / ehrm17.gif < prev    next >
Graphics Interchange Format  |  1996-11-19  |  5.7 KB  |  434x238  |  4-bit (6 colors)
   ocr: SQL Editor WORKKUntitled, SELECT DISTINCT SUM/D1."Total Invoice"], D."State/Prov", D1."Ship VIA" FROM-CUSTOMER.DE"D. "ORDERS.DB" D1 WHERE D1."Customer No" - D."Customer No" AND D1."Sale Date">='01/01/1990 GROUP BY D."State/Prov", D1."Ship VIA" ORDER BY D1."Total Invoice" DESCENDING