You can, however, use MULTIPLE column names with JOIN…USING, as long as both are present in the left hand and right hand side tables (at least in PostreSQL):

http://www.postgresql.org/docs/9.2/static/sql-select.html

… and you can state NATURAL JOIN if *all* of the columns should match, e.g. if doing a self-join.