Re: Use of DISTINCT in INNER JOIN

[Steve Croall]

One possible workaround I can see is to put it in a sub-query, with the outer query returning all the columns required:

SELECT col1, col2
FROM tab1
WHERE col1 IN
(
SELECT DISTINCT a.col1
FROM tab1 a INNER JOIN tab2 b
ON a.col1 = b.col1
WHERE a.col1 in ('value1', 'value2')
ORDER BY a.col1
)
LIMIT 10
;