>
>
>
> As none of the columns of the joined table are used, most probably
> this should be re-written as an EXISTS condition.
> Then neither GROUP BY nor DISTINCT is needed.
>
>
I need the columns from joined tables. To keep it simple, I didn't include
them in the query. EXISTS solution won't work for me.