Can alias in SQL be used within the same table? -
I am otherwise having difficulty understanding whether nickname in SQL can be used in the same table?
In a query, you can use multiple aliases: a single table:
< Given above as alias1.ChildId = alias2.Id on alias2 as the nickname in the INNER table as prefix SELECT alias1.Name, alias2.Name from table. In the code I'm aliasing the
table
as alias1
and alias2
. This is the same table, which has 2 different nicknames.
Comments
Post a Comment