Search Wisdom Axis for specific information

SQL Right Outer Join with Examples, Diagram and Images in Oracle, MySQL, PostgreSQL, MariaDB, IBM DB2, Sybase, SQL Server and Teradata.

SQL INTERVIEW QUESTIONS - INDEX

SQL JOINS: INNER, LEFT, RIGHT, FULL OUTER JOINS What is SQL INNER JOINS What is SQL LEFT OUTER JOINS What is SQL RIGHT OUTER JOINS What is SQL FULL OUTER JOINS

SQL Joins: What is SQL RIGHT OUTER JOIN? Explain with examples.

SQL: RIGHT (OUTER) JOIN
The ‘Right (Outer) Join’ always returns ‘All the records from RIGHT Table’ and ‘Matching Records’ from ‘LEFT Table’.

The following are the tables used to explain joins with examples. TABLE – A: customers_table

customer_number	customer_name	city	state	country
101	John Miller	Los Angeles	CA	USA
401	David Smith	Las Vegas	NV	USA
501	Ted Williams	Chicago	IL	USA
601	Hamilton Morris	New York	NY	USA
901	Franklin Floyd	Austin	TX	USA

TABLE – B: orders_table

order_number	customer_number	order_date
1010505	101	2021-06-06
1010506	201	2021-06-06
1010507	501	2021-06-06
1010508	701	2021-06-06
1010509	901	2021-06-06

SQL JOINS: RIGHT (OUTER) JOIN
"The ‘Right (Outer) Join’ always returns ‘All the records from RIGHT Table’ and ‘Matching Records’ from ‘LEFT Table’."

The following is the pictorial view of the RIGHT (OUTER) JOIN:

RIGHT (OUTER) JOIN Example SQL Code:

SELECT customers_table.customer_number,
customers_table.customer_name,
orders_table.order_numer,
orders_table.order_date
FROM orders_table
RIGHT OUTER JOIN customers_table
ON orders_table.customer_number = customers_table.customer_number;

RIGHT OUTER JOIN Example SQL Code Execution Results:

customer_number	customer_name	order_number	order_date
101	John Miller	10101505	2021-06-06
201		1010506	2021-06-06
501	Ted Willimas	10101507	2021-06-06
701		1010508	2021-06-06
901	Franklin Floyd	10101509	2021-06-06