This sounds like a relational division problem,ie some rows, equal rows, more rows...

Joe Celko has done a good write up on the subject, http://www.simple-talk.com/sql/t-sql-programming/divided-we-stand-the-sql-of-relational-division/