|
|
|
|
|
|
by gav
2603 days ago
|
|
|
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. |
|
|