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
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
Do'stlaringiz bilan baham: