Description
Data A
| sample | country |
|---|---|
| 1 | uk |
| 2 | us |
| 3 | fr |
| 4 | uk |
.
Data B
| country | capital |
|---|---|
| uk | london |
| fr | paris |
| th | bangkok |
.
Output shows the difference between inner join = true/false.
Also shows the difference when inner join=false and the datatables are swapped (main becomes other, and vice versa) to show importance of determining the primary datatable.
Inputs
Outputs
inner join = false (
datatable)inner join = true (
datatable)data when main and other are swapped and innerJoin=false (
datatable)skipped 1 (
datatable)skipped 2 (
datatable)skipped 3 (
datatable)