Yes, but that's only automagic and brittle because it's not an actual join on the foreign key. It's a join on whatever happens to have the same name! Which som

Yes, but that's only automagic and brittle because it's not an actual join on the foreign key. It's a join on whatever happens to have the same name! Which sometimes happens to be the foreign key. The point here is that SQL doesn't have a way of specifying "join on whatever the foreign key is, and nothing else".