[thelist] SQL In need of Optimization....

[Anthony Baratta]

At 06:59 AM 6/29/2001, you wrote:

>so if i check off 4 majors, i might want to see a list of colleges that
>offer at least three of my four choices...
>
>select CollegeID
>     from tblCollegeMajors
>   where MajorID in ( #majorList# )
>   group by CollegeID
>     having count(*) >= #X#

Sweet! That's it!! I knew there was a better way to skin this cat. Thanks 
very much. I owe you a Guinness or a Molson. ;-)   []}

----
Anthony Baratta
President
Keyboard Jockeys