join of tables with shared column names
convenient to
- use same names for related columns
- for example, CAFEMEISTER in EVENTS and NAME in ATHLETES could both be NAME
refine the meaning of join
- can’t have two columns with same name
- so
form a table with both columns
eliminate rows with different values in the two columns
merge the two columns
example
- assume CAFEMEISTER column in EVENTS is now called NAME
- join of EVENTS and ATHLETES:
-
EVENT NAME HOURS SPONSOR
tour-de-café alice 15 coffee- connection
java-jump ben 10 starbucks
seattle-sleepless carol 8 green-mountain
-