home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Visual Basic Programmer'…arterly (Limited Edition)
/
Visual_Basic_Programmers_Journal_VB-CD_Quarterly_Limited_Edition_1995.iso
/
code
/
ch06code
/
listings
/
06list15.txt
< prev
next >
Wrap
Text File
|
1995-08-10
|
458b
|
11 lines
Listing 6.15[em]Using the GROUP BY Clause To Obtain Summary Information for Record Groups
SELECT SL.SalesID, Min(SL.Quantity * RT.Retail) AS Minsls, _
Max(SL.Quantity * RT.Retail) AS Maxsls, _
Avg(SL.Quantity * RT.Retail) AS Avgsls, _
Sum(SL.Quantity * RT.Retail) AS Totsls, _
Sum(SL.Quantity) AS Totvol _
FROM Sales AS SL, [Retail Items] AS RT _
WHERE SL.[Item Code]=RT.[Item Code] _
GROUP BY SL.SalesID