Defining and Using Table Alias Names in SQL Server

Q

How To Define and Use Table Alias Names in SQL Server?

✍: FYIcenter.com

A

When column names need to be prefixed with table names, you can define table alias name and use them to prefix column names. To define an alias for a table name, just enter the alias name right after the original table name in the FROM clause as shown in the following select statement:

SELECT l.id, l.url, r.comment FROM fyi_links l 
   INNER JOIN fyi_rates r ON l.id = r.id
GO
id      url                     comment
101     dev.fyicenter.com       The best
102     dba.fyicenter.com       Well done
103     sqa.fyicenter.com       Thumbs up

 

Using SELECT Statements with Joins and Subqueries in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-30, 700👍, 0💬