Lecture Notes for

A USING clause limits the columns equated in a JOIN to a set of commonly named ones (i.e., same column name in both tables involved in the join.) Since city is not named in the using clause or ON clause, we don't run into the trouble we had with the city column in relational algebra. OK, next is OUTER JOIN. Covered this in Chapter 2. ................
................