sql - Getting distinct rows from a left outer join - Stack Overflow

Try: left outer join (select distinct YOUR_COLUMNS_HERE ...) SUBQUERY_ALIAS on ... In other words, don't join directly against the table, join against a sub-query that limits ...

stackoverflow.com