|
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
seth.rothman
Joined: 29 Jan 2008 Posts: 54 Country: United States |
|
[SA Beta 6] Alias Issue |
|
When including the same table multiple times in the same query, the incrementing alias feature no longer works.
For example, this is what I get when I do a self join:
SELECT *
FROM dbo.Register r
INNER JOIN dbo.Register r
Clearly the second "r" should be "r2". The catch is that it only fails when I type the full name of the table. If I choose it from the Intellisense dropdown, it gets aliased properly.
|
|
Tue Jul 05, 2011 1:34 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7907
|
|
|
|
Thank you. I have logged that issue into our issue tracking system, #SA14838
|
|
Tue Jul 05, 2011 3:50 pm |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|