Sql server® 2012 t-sql fundamentals

anSI SQL-92 Syntax

Using the ANSI SQL-92 syntax, you specify the INNER JOIN keywords between the table names. The 

INNER keyword is optional, because an inner join is the default, so you can specify the JOIN keyword 

alone. You specify the predicate that is used to filter rows in a designated clause called ON. This 

predicate is also known as the join condition.

www.it-ebooks.info

---

104  

Microsoft SQL Server 2012 T-SQL Fundamentals

For example, the following query performs an inner join between the Employees and Orders 

tables in the TSQL2012 database, matching employees and orders based on the predicate E.empid = 

O.empid.

USE TSQL2012; 

 

SELECT E.empid, E.firstname, E.lastname, O.orderid 

FROM HR.Employees AS E 

  JOIN Sales.Orders AS O