Home Forums SQL Server 2012 SQL Server 2012 - T-SQL avoiding distinct operator ? RE: avoiding distinct operator ?
ZZartin
SSC-Dedicated
Points: 30894
More actions
December 27, 2017 at 6:47 am
#1973572
Yes, change the join criteria so it's not generating duplicates, but it kind of depends on what's generating the duplicates. In this case one option might be to change the t3.c2 in (10,20,30,40) clause to a series of union statements.