Re: [SQL] SQL gotcha

2011-02-14 Thread Achilleas Mantzios
Στις Tuesday 15 February 2011 01:29:25 ο/η Dean Gibson (DB Administrator) έγραψε: > As you all know, when you specify an alias for a table or column name, > the keyword "AS" is usually optional. I personally like to always > include the "AS" keyword, if for no other reason than readability, and

[SQL] SQL gotcha

2011-02-14 Thread Dean Gibson (DB Administrator)
As you all know, when you specify an alias for a table or column name, the keyword "AS" is usually optional. I personally like to always include the "AS" keyword, if for no other reason than readability, and I presume that always using "AS" might catch some syntactic errors as well. However,