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, 3258🔥, 0💬
Popular Posts:
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Concatenate Two Character Strings Together in SQL Server Transact-SQL? Concatenating two char...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...