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

image

Leave a Comment


x

You might be Interested in these Posts

C Program to find the G.C.D of a number using Recursive function

Problem Write a program in C to find the find the G.C.D of a number using recursion and display the ...

C Program to print a Half Pyramid using *

Problem Write a program in C to print Half pyramid using * as shown. * * * * * * * * * * ...

C Program to display Positive factors of a number

Problem Write a program in C to display all the positive factors of a number enter by the user. Ho...