Codechef4u is a community for computer professionals,by computer professionals,just like you; who loves sharing and helping each others,Join them
Share your post

Inner Join

Original Tables Data:

Products Table:


Categories Table:


Inner Join:

This join returns common or matching records/rows from both the database tables (left table and right table).This s the most used join in the SQL. In the join condition, you can also use other operators like <,>,<>.


Syntax:

SELECT
column_name(s)
FROM Table1 (Left Side Table)
INNER JOIN Table2 (Right Side Table)
ON Table1.column_name=Table2.column_name;


Example:

SELECT
ProductName AS [Product Name]
,UnitPrice AS [Price]
,CategoryName AS [Product Category],ImagePath AS [Image]
 FROM Products P
INNER JOIN Categories C ON P.CategoryID=C.CategoryID


Inner join t-sql query will return result 



Invalid entry,please enter valid data.

Loading