When or why would you use a right outer join instead of left?

by

The only reason I can think of to use RIGHT OUTER JOIN is to try to make your SQL more self-documenting.

You might possibly want to use left joins for queries that have null rows in the dependent (many) side of one-to-many relationships and right joins on those queries that generate null rows in the independent side.

This can also occur in generated code or if a shop’s coding requirements specify the order of declaration of tables in the FROM clause.

More Related Contents:

  1. Which one of these Queries are wrong and which is correct (SQL) [closed]
  2. SQL Selecting from three tables
  3. Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc
  4. How to implement a many-to-many relationship in PostgreSQL?
  5. Entity Attribute Value Database vs. strict Relational Model Ecommerce
  6. How can I schedule a job to run a SQL query daily?
  7. Reset identity seed after deleting records in SQL Server
  8. What is the difference between JOIN and UNION?
  9. Generate a resultset of incrementing dates in TSQL
  10. Database Design for Revisions?
  11. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  12. Does SQLite3 not support foreign key constraints?
  13. How would you implement sequences in Microsoft SQL Server?
  14. The Next-gen Databases [closed]
  15. SQL how to compare two tables for same data content?
  16. What does =* mean?
  17. Does MS Access support “CASE WHEN” clause if connect with ODBC?
  18. MySQL equivalent of DECODE function in Oracle
  19. What datatype to use when storing latitude and longitude data in SQL databases? [duplicate]
  20. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  21. Favourite performance tuning tricks [closed]
  22. How do I alter the position of a column in a PostgreSQL database table?
  23. Is it necessary to create tables each time you connect the derby database?
  24. Venn Diagram for Natural Join
  25. Database efficiency – table per user vs. table of users
  26. SQL ON DELETE CASCADE, Which Way Does the Deletion Occur?
  27. Find rows that have the same value on a column in MySQL
  28. what is the difference between GROUP BY and ORDER BY in sql
  29. Temporal database design, with a twist (live vs draft rows)
  30. Executing SQL query on multiple databases

Leave a Comment