We wish to combine information from multiple data frames into a single data frame via join operations such as:
Left Join, Right Join, Inner Join, and Full Join.
This section is organized as follows:
Join Types: where we cover how to
the different join types and their meaning.
Join Columns: where we cover how
to specify join columns.
Join Special Cases: We cover
different challenges we might face when performing a join operation.