Steve Jones - SSC Editor (9/2/2015)
I do agree with the = and try to use it, precisely because complex code becomes hard to read when the name is buried far to the right of my screen. However my habit is "as", so I struggle to change and get some inconsistent code.
I can sympathize with that. I worked with Oracle very early on and I've worked with Ingres and played with Postgres (and had a very brief connection with DB2, which was sheer hell after using decent or half-way decent RDBMS; can't say I worked with it, because it didn't work) so I grew into the habit of either not aliasing or using (or omitting) AS. I actually think the "=" method is far better, but changing existing code to use it was just too error-prone. I keep on forgetting to use it with new code.
Tom