TOP CATEGORIES

×

What is the use of right join in SQL?

V

Vijaya Shree

RIGHT JOINING in SQL

The SQL RIGHT JOIN or SQL RIGHT OUTER JOIN keyword is used to return all records from the RIGHT TABLE (for example Table_2), and the matched records from the LEFT TABLE (for example Table_1). For more understanding about Right Join see the below-mentioned query syntax example:

SYNTAX for RIGHT JOINS

SELECT column_name(s)

FROM Table_1 RIGHT JOIN Table_2

ON column_name_1 = column_name_2

WHERE [condition]

SYNTAX for RIGHT OUTER JOIN

SELECT column_name(s)

FROM Table_1  RIGHT OUTER JOIN Table_2

ON column_name_1 = column_name_2

WHERE [condition]

SQL RIGHT JOINING MAPPING IMAGE

right joining in sql
0 votes

Your Answer

Email: advertise@gdatamart.com

Donate: To Support US

© 2024 GDATAMART.COM (All Rights Reserved)