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