|
|
| Тема |
 ah tozi SQL [re: Kiril Hadjiew] |
|
| Автор |
e-de () |
|
| Публикувано | 22.08.00 19:55 |
|
|
|
Mai ne ti razbiram iasno problema, no:
SELECT Table1.Towar, Sum(Table1.Quantity) AS SumOfQuantity, (Select Sum(Table1.Quantity) FROM Table1 Where TDate>=#8/2/00#) AS GrossTotal
FROM Table1
Where TDate>=#8/2/00#
GROUP BY Table1.Towar
tova ti vrashta sumi po Towar vav kolona 2 i total ot vs. towari v kolona 3 (edna i sashta stoinost za vs. tovari).
Testval sam s MS Access 97 kato data source, do nego stigam pres BDE na Delphi 5 i ODBC DSN.
Ako ne raboti s DB/DBF to problema e na data storageto, ne na BDE-to.
| |
| |
| 
|
|
