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