Right Join

Definitions

1. A SQL join that returns all rows from the right (second) table and the matching rows from the left (first) table, filling in NULLs for left-table columns where no match exists. It is the mirror of a LEFT JOIN.

   In plain English: A way to combine two database tables that keeps every row from the second table, even if there's no matching row in the first.

   Example: "Switch to a RIGHT JOIN on the orders table so we see every order even if the customer record was soft-deleted."

Related Terms

• query planner
• index
• stored procedure
• trigger
• foreign key
• Join
• Outer Join
• Subquery
• MariaDB
• CockroachDB