Products Table

Categories Table

Right outer Join or Right join:

The RIGHT JOIN keyword returns all rows from the right table (Categories), with the matching rows in the left table (Product). The result is NULL in the left side when there is no match. 

Syntax:

SELECT
column_name(s)
FROM Table1 (Left Side Table)
RIGHT JOIN Table2 (Right Side Table)
ON table1.column_name=table2.column_name
 
or:
 
SELECT
column_name(s)
FROM Table1 (Left Side Table)
RIGHT OUTER 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

RIGHT OUTER JOIN Categories C ON P.CategoryID=C.CategoryID 

Right join t-sql query will return result