Brandie Tarvin (9/19/2013)
I know half a dozen ways to do what you've requested. But any easier than the easiest way I posted above?If you find one, let me know.
Rather than writing the query you described as the final step of your method, wouldn't it be easier to write
SELECT * FROM #ALLSELLERS
EXCEPT SELECT * FROM #WORSTSELLERS
EXCEPT SELECT * FROM #TOPSELLERS
or even
SELECT * FROM #ALLSELLERS EXCEPT (
SELECT * FROM #WORSTSELLERS UNION ALL SELECT * FROM #TOPSELLERS)
if you think using brackets makes it less confusing.
Tom