Defining and Using Table Alias Names in SQL Server


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



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.url, r.comment FROM fyi_links l 
   INNER JOIN fyi_rates r ON =
id      url                     comment
101       The best
102       Well done
103       Thumbs up


"LEFT OUTER JOIN ... ON" - Writing Queries with Left Outer Joins in SQL Server

"INNER JOIN ... ON" - Writing Queries with Inner Joins in SQL Server

Using SELECT Statements with Joins and Subqueries in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-10-30, 1443🔥, 0💬