Class 10

Based 21/05/19 dat602 class

Joins but more…

Straight joins are weird, I might need to look into them but Todd doesn’t know what they are so I don’t think they will be that important.

Natural joins are similar to other joins but might be useful to look into.

Full outer joins don’t exist within MySQL but unions are similar so I might want to look further into these as Full outer joins might be useful. For example with my project I might want to join my piece table with the board table to represent the board with the pieces in their places.

During this class we will be working on project work.

I am doing we with my project currently I need to finish off my create table statement, create a written narrative and make sure all of my columns name line up with what I have used in my narratives.