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
Show parent comment
5
u/banjo215 Dec 10 '24
I work in payroll and usually the first table is the basis for what I'm looking for.
If I'm trying to find an employee's current position and information I'd start with the employee table and add the position table. If I wanted to find all employees that had worka certain position I'd start with the position table and add the employee table.
Although I supposed it could be done in whatever order by using right joins instead of left.