Collections:
Defining and Using Table Alias Names in SQL Server
How To Define and Use Table Alias Names in SQL Server?
✍: FYIcenter.com
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
⇒ "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
2016-10-30, 1369🔥, 0💬
Popular Posts:
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...