Is there a better way to re-write below type of queries? Most developers tend to keep DISTINCT Operator to avoid duplicates. Is there a nice alternate way to avoid DISTINCT and still getting results with duplicates and has better performance?
FROM t1 INNER JOIN t2 ON t1.c2 = t2.c4
INNER JOIN t3 ON t3.c1 = t2.c3 and t3.c3 = t1.c6
WHERE t1.iscurrent = 0
and t3.c2 in (10,20,30,40)