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, 1847🔥, 0💬
Popular Posts:
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...