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

Anthony Baratta Anthony at Baratta.com
Fri Jun 29 12:53:19 CDT 2001

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
Keyboard Jockeys

More information about the thelist mailing list