I struggle to think of time I used a right join in the 20-odd years I've used SQL. The example shows a case where you'd want foreign keys to enforce referentia

I struggle to think of time I used a right join in the 20-odd years I've used SQL. The example shows a case where you'd want foreign keys to enforce referential integrity, though FKs aren't fashionable these days. You shouldn't be able to have an entry for owner_id 8 in the Dogs table without a corresponding Owner.