home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a087 / 6.ddi / EMPLSL90.QP_ / EMPLSL90.bin
Encoding:
Text File  |  1994-02-02  |  1.4 KB  |  33 lines
  1.  
  2. * WIZNAME = WZ_BQUER
  3. * VERSION = .62
  4. * TIMESTAMP= 474063590.0000
  5. * TABLES = "C:\FPW26\SAMPLE\CATALOG\SALESMAN.DBF";"C:\FPW26\SAMPLE\CATALOG\INVOICES.DBF"
  6. * JOINS = Invoices,"Salesman",Salesman,"Salesman",1
  7. * FIELDS = Salesman.name;Salesman.salesman;TOTALSALES=SUM(Invoices.itotal)
  8. * FILTER = 0,0,"Invoices.idate",5,"1/1/90",0
  9. * FILTER = 0,0,"Invoices.idate",2,"1/1/91",0
  10. * SORT FIELDS = TOTALSALES
  11. * SORT ORDER = DESCENDING
  12. * GROUP = Salesman.salesman:1C
  13. *    SQL Select statement for Mailmerge Wizard:
  14. *SELECT Salesman.name,Salesman.salesman,;
  15.         SUM(Invoices.itotal) AS TOTALSALES ;
  16. *    FROM ;
  17. *         LOCFILE("C:\FPW26\SAMPLE\CATALOG\SALESMAN.DBF","DBF","Where is Salesman.DBF ?"),;
  18. *        LOCFILE("C:\FPW26\SAMPLE\CATALOG\INVOICES.DBF","DBF","Where is Invoices.DBF ?");
  19. *    WHERE Salesman.Salesman=Invoices.Salesman;
  20. *    AND (Invoices.idate>={1/1/90}.AND.Invoices.idate<{1/1/91});
  21. *    ORDER BY TOTALSALES DESCENDING;
  22. *    GROUP BY Salesman.salesman;
  23. *    INTO CURSOR Query
  24. SELECT Salesman.name,Salesman.salesman,;
  25.         SUM(Invoices.itotal) AS TOTALSALES ;
  26.     FROM ;
  27.          LOCFILE("C:\FPW26\SAMPLE\CATALOG\SALESMAN.DBF","DBF","Where is Salesman.DBF ?"),;
  28.          LOCFILE("C:\FPW26\SAMPLE\CATALOG\INVOICES.DBF","DBF","Where is Invoices.DBF ?");
  29.     WHERE Salesman.Salesman=Invoices.Salesman;
  30.     AND (Invoices.idate>={1/1/90}.AND.Invoices.idate<{1/1/91});
  31.     ORDER BY TOTALSALES DESCENDING;
  32.     GROUP BY Salesman.salesman;
  33.     INTO CURSOR Query