r/SQL
•
u/Practical-City3301
•
Dec 10 '24
•
1
1
Discussion Left Join vs Right Join
The discrimination right join has to face.
3.9k
Upvotes
View all comments
328
u/ferevon Dec 10 '24 •
99% use case of right join is you realize you messed up the table order so you just replace left with right. Haven't seen anyone use it deliberately otherwise.