Re:The girl with the ANSI tattoo
by HarrisonFisk on Thursday May 31, 2012 @05:09PM
(#4050376)
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.
Realistically that they started the query with keywords optional, then moved to them being required (which, it should be noted, a good query planner would effective make an inner join). On the scale of evils of SQL, it lies somewhere around "friendly benign".
Any excuse for this? :)