T-SQL Anti-Patterns: ANSI-89 Joins

My first anti-pattern is a pet peeve.  In many cases, it is not necessarily terrible, but like any great code smell, seeing ANSI-89 joins tells me that there may be deeper issues involved. What do I mean by an ANSI-89 join?  Prior to ANSI-92's specification of INNER, OUTER, and CROSS JOIN, SQL developers had a…

Advertisement