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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by SCFlam

  1. SCFlam

    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...
  2. SCFlam

    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...

Part and Inventory Search

Back
Top