Question Details

No question body available.

Tags

sql

Answers (6)

February 14, 2026 Score: 1 Rep: 526,354 Quality: Low Completeness: 0%

Nothing really gained by writing a left join with right join. Some consider right join as not best practice and refrain from using it.

February 14, 2026 Score: 1 Rep: 11 Quality: Low Completeness: 30%

There was a similar discussion on this. Can refer to this link for your reference:
When or why would you use a right outer join instead of left?

February 14, 2026 Score: 1 Rep: 457,572 Quality: Low Completeness: 20%

Another question on much the same lines Does "Right Outer Join" have any useful purpose?

February 14, 2026 Score: 0 Rep: 87,762 Quality: Low Completeness: 40%

Some prefer a INNER b ON a.id=b.id RIGHT c ON c.id=b.id as it avoids brackets and "oddly" positioned predicate; c LEFT (a INNER b ON a.id=b.id) ON a.id=c.id. With appropriate multiline formatting and indentations, I still advise avoiding RIGHT JOIN, for consistency and comprehension.

February 14, 2026 Score: 0 Rep: 15,646 Quality: Low Completeness: 30%

consistency? Consistency with what? With the SQL standards?

February 14, 2026 Score: 0 Rep: 87,762 Quality: Low Completeness: 0%

Coding practices. Some people don't use it, I recommend everyone not use it, where ever I work.