home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Boston 2
/
boston-2.iso
/
DOS
/
PROGRAM
/
DATABASE
/
SQL
/
RPT4.FRM
< prev
next >
Wrap
Text File
|
1993-12-01
|
658b
|
26 lines
--RPT4.FRM (Be patient when running this one. It actually
-- contains three queries)
--
HT SALES REPORT
HT MONOLITH MANUFACTURING
HTCustomer Name Product QTY
HT--------------- ---------- ---
DTXXXXXXXXXXXXXXX XXXXXXXXXX 999
1T ------
1T The customer total is 99,999
1T
GT -------
GT GRAND TOTAL ............999,999
ET
ET^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
ET END OF REPORT
ET^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
DC name, descrip, qty
1B name
1C sum(qty)
GC sum(qty)
TA sales,prod,cust
WH sales.cc = cust.code and
WH sales.pc = prod.code