home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 3 / Developers_Source_Vol_03_1996.iso / parad / may95 / ehrm11.gif next >
Graphics Interchange Format  |  1995-11-16  |  18.8 KB  |  661x524  |  4-bit (16 colors)
   ocr: Paradox for Windows File Edit View Query Properties Tools Window Help ?1 A5 5> BBE E BEE HF ab Query:501 1.QBE CUSTOMER.DB/Customer Nor Name Street City State/Prov Zip/Postal C Cour join1 ORDERS.DB Order No Customer Nor Sale Date Ship Date Ship VIA Total Invoice Amd join1 >=1/1/90 Calc Sum SQL Editor .<untitied> SELECT DISTINCT D."State/Prov", D1."Ship VIA", SUM/D1."Total Invoice"] L FROM COSTOMERLDB" D, ORDERS.DB"DI WHERE D1."Customer No" == D."Customer No"] AND (D1."Sale Date")=01/01/19907 GROUP BY D."State/Prov', D1."Ship VIA" ORDER BY D."Slate/Prov:Dl-Shp VIA"