Combining tables

Data models show us how data points within separate tables are logically connected with each other. In the practice of data analytics, we often need to combine data together by leveraging the logic relationships which the data model describes. The most common operation for combining two tables into a third one is called Join. By combining two tables together, we cross-enrich them as we merge all the information we have on a specific event or entity. The join operation will take the two tables and match the rows that have the same values in the columns we specify (Matching Columns). Let's imagine we have the following two tables, which refer to sales transactions and to the product master data:

Sales
Product	Date	Amount
Gibson Explorer B-2	21-Dec	1040 ...