Added comment on the join method, how aliasing is required where column names are the same.