Well, this probably is just a "matter of style" question but I really would like to learn a little more about the difference between JOIN t ON <equal condition> and JOIN t USING(<list of columns>).
Of course I'm assuming the two tables have the same columns, with the same name and the same data-types. In such case:
- is there any real difference between the two syntaxes?
- is the
USINGclause supported in all (or at least the most important) dbms s?
I already read about NATURAL JOIN on w3resource.com and the following question about NATURAL JOIN vs ON clause but they don't seem to answer the previous two questions...
Moreover, neither the w3resource.com EQUI JOIN section nor INNER JOIN section do mention the USING "technique".