Join the Tables

The stocks table in the all$\_$stocks$\_5$yr data source contains the majority of the information you will need for this project, but it's missing the names of businesses, which can be found in the symbols table from the ticker$\_$symbols data source, so you will need to join these tables.

Perform a cross$-$database join to join the stocks and symbols tables.

The symbols table is missing several businesses, so select a join that will only include businesses that are in both tables.

The Ticker Symbol field from the all$\_$stocks$\_5$yr file should be used to join to the Symbol field from the ticker$\_$symbols file.