Example joins
The following examples show what happens to two data sets when each type of join operation is applied to them.
Here are the two data sets:
| Left Input Data Set | Right Input Data Set | ||
|---|---|---|---|
| Status | Price | Price | ID |
| sold | 125 | 113 | NI6325 |
| sold | 213 | 125 | BR9658 |
| offered | 378 | 285 | CZ2538 |
| Pending | 575 | 628 | RU5713 |
| Pending | 649 | 668 | SA5680 |
| Offered | 777 | 777 | JA1081 |
| Offered | 908 | 908 | DE1911 |
| Pending | 908 | 908 | FR2081 |
Price is the key column which is going to be joined on, and bold type indicates where the data sets share the same value for Price. The data sets are already sorted on that key.