Koen Verbeeck (1/8/2013)
Not sure what this question tries to teach us....
I guess.. this; if the aliases are been removed in SELECT block, it gives below error on ambiguity for couple of column names. (some sort.... author might had in mind)
Msg 209, Level 16, State 1, Line 3
Ambiguous column name 'Name2'.
Msg 209, Level 16, State 1, Line 4
Ambiguous column name 'Name3'.
(looks like this was one of the "out of the box" experience 🙂 )
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.