• I liked the article...I am amazed that people still use pre ansi-92 syntax...it has been over 10 yrs already.

    In addition to using ansi join syntax, I like to move the where clause restrictions to the join level where applicable...that way all of my join information is in the same spot.