10 years ago the problem I had with Rdb's implementation of USING(department_id) was that neither d. nor e. aliases were allowed for the join column - it could only be refered to as "department_id". So if you had a third table with with a column "department_id" there was no simple way of resolving the ambiguity. (This may not be strict ANSII behaviour.)