Inner Join in SQL Server

Published on August 27, 2016 by abundantcode

Filed under SQL Server

Last modified August 27, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 405 times

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
SELECT FirstName , PhoneNumber 
FROM Person.Person INNER JOIN Person.PersonPhone
on Person.BusinessEntityID = PersonPhone.BusinessEntityID


If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Comment


You might be Interested in these Posts

How to hide horizontal or vertical scroll bar using VBA Code in Excel ?

Here's a VBA code that hides the horizontal and vertical scroll bar in Microsoft Excel. How to hide...

Deleting all the hidden rows and columns in the active worksheet using VBA

Do you want to delete all the hidden rows and columns in the active worksheet in Microsoft Excel usi...

Displaying all the worksheet names in Excel using VBA Code

Do you want to display the names of the worksheets in the excel workbook ?. Here;s how you can do it...