Mike, thank you, I am glad that SQL Server 7.0 suports that syntax. The other day, after you gave me assurance that I can have both 6.5 and 7.0 on the same computer, I installed 7.0 desk top edition. I think I will stop reading "SQL for Dummies", read "SQL for Smarties" instead :)


>SQL Server 7.0 supports the same syntax. SQL Server 6.5 doesn't. The following query came from one of my favorite books: Joe Celko's SQL FOR SMARTIES: Advanced SQL Programming (ISBN: 1-55860-323-9) pg. 327
>
>SELECT DISTINCT COUNT(*), a.Salary
>FROM Employees a, Employee b
>WHERE a.salary <= b.salary
>GROUP BY a.salary
>HAVING COUNT(*) < 3
>
>You'll probably want to change the 3 to a 10.
>
>HTH
>
>-Mike