My Day Analysis class today:

On the practical aspect of joining data

When you join data you are using the field of data that is the same in both tables and it the same data type . Sometimes they will named the same and sometimes they will be not.An example was given of a data field of product ID and Sales ID ; linking this together may give no results or limited results because sales ID and Product ID should not be linked .