On: Don't use DISTINCT as a "join-fixer"

[gigatexal]

You mean the where exists/not exists concept? Or the select 1 usage in that correlated subquery?

[funnymony → gigatexal]

1