Right join in sql server

Introduction to the SQL Server RIGHT JOIN clause

The RIGHT JOIN combines data from two or more tables. The RIGHT JOIN clause starts selecting data from the right table and matching with the rows from the left table. The RIGHT JOIN returns a result set that includes all rows in the right table, whether or not they have matching rows from the left table. If a row in the right table does not have any matching rows from the left table, the column of the left table in the result set will have nulls.
The following shows the syntax of the RIGHT JOIN clause:
In this syntax, T1 is the left table and T2 is the right table.
Note that RIGHT JOIN and RIGHT OUTER JOIN is the same. The OUTER keyword is optional.
The following Venn diagram illustrates the RIGHT JOIN operation:
SQL Server RIGHT JOIN illustration

SQL Server RIGHT JOIN example

We will use the sales.order_items and production.products table from the sample database for the demonstration.
products order_items
The following statement returns all order_id from the sales.order_items and product name from the production.products table:
Here is the output:
SQL Server RIGHT JOIN example
The query returned all rows from the production.products table (right table) and rows from sales.order_items table (left table). If a product does not have any sales, the order_id column will have a null.
To get the products that do not have any sales, you add a WHERE clause to the above query to filter out the products that have sales:
The following picture shows the output:
SQL Server RIGHT JOIN - rows from the right table only
The following Venn diagram illustrates the above RIGHT JOIN operation:
SQL Server RIGHT JOIN - select only rows from the right table
In this tutorial, you have learned how to use the SQL Server RIGHT JOIN to query data from two tables.

Post a Comment

0 Comments