Inner Join in SQL Server

You can use inner join to get the result of two tables that match the criteria.

For example , assume that you have a Person table and a Phone Number table where every person would have 0 or more phone number associated to him and you wish to get the person records who have at least one phone number.

Here’s the query on how to do it.

Use AdventureWorks2014
GO
SELECT FirstName , PhoneNumber 
FROM Person.Person INNER JOIN Person.PersonPhone
on Person.BusinessEntityID = PersonPhone.BusinessEntityID
image