Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Mutually Exlusive Sets
Quick edit, last part of last query, visible=0 not visible=N, here: Select ex.excid, ex.abbr, ex.numexclusion, exc.exccomboid From Combinations exc Join Exceptions Ex on Ex.excid=Exc.excid Where exc.exccomboid in (select exccomboid from MasterC where visible=N)) N on...- SCFlam
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Mutually Exlusive Sets
Hi, I'm new to this forum, so forgive me if this is too much information or not the right forum. I've been struggling with a strategy for getting this information for somet time and I'd like to see if there's a way to effectively exclude records based on the result set of a query. Sample Data...- SCFlam
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
