Right but that’s not how SQl executes unfortunately. You go to Starbucks then ask for what you need. SQL does a Cartesian product of all the tables you need, then filters with the ON clause. Only then can you “order” what you want in SELECT.
In standard SQL syntax you’re essentially asking for what you want at your house then driving to a Starbucks.
More readable but doesn’t follow the execution order at all.
In standard SQL syntax you’re essentially asking for what you want at your house then driving to a Starbucks.
More readable but doesn’t follow the execution order at all.