SQL INNER JOIN

INNER JOIN is the most frequently used join in SQL. These joins are also referred to as EQUIJOIN. It creates a new result set that comprises the matching records of the joined tables on the basis of joining ground. If the condition on the predicate meets then it will return the matched pair of rows of Table A and Table B.

• Syntax of INNER JOIN –

SELECT column1 , column2 , column3 , ... , columnN FROM Table A
INNER JOIN
Table B ON TableA.column_name = TableB.column_name ;


Example – Consider these two tables the Product table and the Manager table.

Product Table

Manager Table

Now, let us suppose we want to know the Regional managers of the cities. Below is the statement that shows the results.

SELECT A.Category,A.City,A.[Customer Name],A.Region,B.[Regional Manager]
FROM [dbo].[Products] AS A
INNER JOIN [dbo].[Manager] AS B
ON A.Region = B.Region;


This output is the small section of the output by executing the above query –

Follow us on Twitter, Facebook, Linkedin, and Tableau Public to stay updated with our latest blog and what’s new in Tableau.

If you are looking forward to getting your data pipeline built and setting up the dashboard for business intelligence, book a call now from here.