Hacker News new | ask | show | jobs
by HarrisonFisk 5129 days ago
The MySQL optimizer will actually notice and remove the outer join aspect automatically. So I have often done this out of pure laziness if I start with an outer join, but really end up needing an inner join.