Joining two tables for a basic SELECT query

Joining two tables for a basic SELECT query

In this video we are playing detective because there is no defined relationship between the two tables. There is, however, an intuitive relationship based on the semantics of the field names.