left looks like a table alias as it was, now it is clear that it is actually LEFT OUTER JOIN
(if you prefix left with as, the query doesn't run, so it is clearly not being interpreted as a table alias, even if it is currently "spelled" like it is one)
leftlooks like a table alias as it was, now it is clear that it is actuallyLEFT OUTER JOIN(if you prefix
leftwithas, the query doesn't run, so it is clearly not being interpreted as a table alias, even if it is currently "spelled" like it is one)