Can we replace RIGHT JOIN with a LEFT JOIN?

Rajeev Kumar

3y905SQL Server

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishal Yelve3y ago
Yes, you can replace Right Join with Left Join
Amit Mohanty3y ago
Yes, you can replace a RIGHT JOIN with a LEFT JOIN in SQL Server by swapping the order of the tables in the join and reversing the direction of the join.
For example, consider the following query using a RIGHT JOIN:
```
SELECT * FROM Table1 RIGHT JOIN Table2 ON Table1.ID = Table2.ID
```
The above returns all the rows from Table2 are returned along with the matching rows from Table1.
To replace the RIGHT JOIN with a LEFT JOIN, we can swap the tables and reverse the join direction like below query.
```
SELECT * FROM Table2 LEFT JOIN Table1 ON Table2.ID = Table1.ID
```
The above returns all the rows from Table1 are returned along with the matching rows from Table2.
Naimish Makwana3y ago
Hello Rajiv,

Yes, it is possible to replace a RIGHT JOIN with a LEFT JOIN by reversing the order of the tables in the query and using a LEFT JOIN instead of a RIGHT JOIN.

For example, suppose we have two tables named "students" and "courses" with the following structures:

Table: students

id name

1 Alice

2 Bob

3 Carol

Table: courses

id name student_id

1 Physics 1

2 Math 2

3 Biology 1

To get a list of all students and their corresponding courses, we could use a LEFT JOIN with the "students" table as the left table and the "courses" table as the right table:
```
SELECT students.name, courses.name 
FROM students
LEFT JOIN courses
ON students.id = courses.student_id;
```
This will produce the following result:

name name

Alice Physics

Alice Biology

Bob Math

Carol NULL

As you can see, the LEFT JOIN returns all the rows from the left table (students) and matching rows from the right table (courses). In this case, it also includes students who have not taken any courses (Carol) and includes a NULL value for the course name when there is no match.

We could also achieve the same result by using a RIGHT JOIN with the "courses" table as the left table and the "students" table as the right table:
```
SELECT students.name, courses.name 
FROM courses
RIGHT JOIN students
ON students.id = courses.student_id;
```
This will produce the same result as the previous query. However, using a LEFT JOIN is generally considered to be more intuitive and easier to read.

Thanks

Naimish Makwana

id	name
1	Alice
2	Bob
3	Carol

id	name	student_id
1	Physics	1
2	Math	2
3	Biology	1

name	name
Alice	Physics
Alice	Biology
Bob	Math
Carol	NULL

Jignesh Kumar3y ago

Yes, We can, just need to switch that table and use left join instead of right join, you can check this one,

SELECT EmployeeID, EmployeeName, Gender
FROM   Employees RIGHT JOIN Genders 
ON     Employees.GenderID = Genders.GenderID

SELECT EmployeeID, EmployeeName, Gender
FROM   Genders LEFT JOIN Employees 
ON     Employees.GenderID = Genders.GenderID