Inner Joins in SQL Server

The INNER JOIN keyword selects records that have matching values in both tables. 

Example Query: 

SELECT Table_1.[Employee ID], Table_2.MarketID 

FROM Table_1 

INNER JOIN Table_2 

ON Table_1.MarketID = Table_2.MarketID; 

Here I have Two tables: Table_1 and Table_2, both having a column Employee Id and Market id. 

The inner join returns the rows when there is at least one match in both tables.

SQL INNER JOIN

The INNER JOIN keyword return rows when there is at least one match in both tables.

SQL INNER JOIN Syntax

PS: INNER JOIN is the same as JOIN.

SQL INNER JOIN Example

The "Persons" table:

The "Orders" table:

Now we want to list all the persons with any orders.

We use the following SELECT statement:

The result-set will look like this:

The INNER JOIN keyword return rows when there is at least one match in both tables. If there are rows in "Persons" that do not have matches in "Orders", those rows will NOT be listed.

Please refer the below link

http://www.w3schools.com/sql/sql_join_inner.asp


Thanks