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
/
06list16.txt
< prev
next >
Wrap
Text File
|
1995-08-10
|
518b
|
12 lines
Listing 6.16[em]The HAVING Clause Filters the Display of the Selected Group Records
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 _
SL INNER JOIN RT ON SL.[Item Code]=RT.[Item Code] _
GROUP BY SL.SalesID _
HAVING Sum(SL.Quantity * RT.Retail) > 3000