Join Statement

The thing is that we need to consider which table should be a key table.(or for column)