Keep the right side with RIGHT JOIN

An order report may need guest purchases without an identified customer. Make orders the preserved side and identify exactly where a missing value appears.

Choose the table whose rows must remain even without a match on the other side.

Keep the right side with RIGHT JOIN: Choose the table whose rows must remain even without a match on the other side.