Lukas Eder covers an esoteric bit of syntax:
Some SQL operators are as esoteric as they’re powerful. One of the oldest operator that you’ve likely hardly ever used in real world applications is
NATURAL JOINwhich is the default in relational algebra. We’ve covered a funky use-case forNATURAL JOINearlier on this blog.
Click through for a similar example using JOIN USING. It’s best to be specific in your SQL queries, at least the permanent ones that you add to scripts you expect to re-run in the future or make part of applications.