What is the use of right join in SQL?

LAST READ: APR 12 2024 | Q. BY: MIKE DEVID

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 Us: advertise@gdatamart.com

Donate Us: Support to GDATAMART

LifeStyle & Fun

© 2024 GDATAMART.COM (All Rights Reserved)