IN everything but SQL2000 this is not a problem. Seems in 2000, the tableName does not get
an automatic name reference, such that the use of tableName.xxx results in a syntax error.
You must alias the table name even if it is the same name.
SELECT tableName.Col FROM tableName tableName
License & copyright
StinkySQL weblog and any related pages, including the weblog's archives are licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License.
Posts
No comments:
Post a Comment
Be nice... it's the only internet we have.