Section 3.3. Join and Concatenation

In this section we introduce the basic concepts to put together two different data sets: join and concatenation. Join puts together two data sets side by side, joining the rows on a common identification value (the key). Concatenation puts together two data sets on top of each other, joining together the columns with the same header. This is the basic concept. However, many flavors of join and concatenation exist.