If omiting the ON clause is assumed to follow the fields based on the referential integrity, how would you do a Cartesian product?
Edit: using AUTO The advantages to this is a little less typing and you don't have to know how they are joined or remember a complicated join. If the relationhip changes, it is handled automatically, but that rarely happens except in early development.
What you have to do now is decide if all of your AUTO joins hold up during a relationahip change to match the intent of your select statement.
