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, 1449🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...