An inner join is a join in which the values in the columns being joined are compared using a comparison
operator.
SELECT *
FROM HumanResources.Employee AS e
INNER JOIN Person.Person AS p
ON e.BusinessEntityID = p.BusinessEntityID
ORDER BY p.LastName
Comments
Please sign in to leave a comment.