data-lessons / library-sql-DEPRECATED

SQLite lesson for librarians NOW MOVED > https://github.com/LibraryCarpentry/lc-sql
https://github.com/LibraryCarpentry/lc-sql
Other
2 stars 16 forks source link

different joins, other than rows 1:1 , name collisions for rows #40

Open steltenpower opened 7 years ago

steltenpower commented 7 years ago

In http://data-lessons.github.io/library-sql/04-joins-aliases/

I see nothing mentioned about different types and naming for joins, as in https://www.w3schools.com/sql/sql_join.asp

I'd like it more explicitly explained what happens when it's other than 1:1 row-match

Also 2 tables can have exact same row names. I'd like to see an explanation, or a remark at least