[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
President
Keyboard Jockeys
More information about the thelist
mailing list