Inner join |
![]() |
Select all records from list 1 and list 2, where the join condition is met. An inner join returns records at the intersection of the two lists.
List 1
ID | Name |
15 | Bohr N. |
13 | Helmholtz H. |
11 | Maxwell J. C. |
18 | Planck M. |
List 2
ID | Birth year |
11 | 1831 |
18 | 1858 |
13 | 1883 |
17 | 1905 |
Inner-joined lists
ID | Name | ID | Birth year |
13 | Helmholtz H. | 13 | 1883 |
11 | Maxwell J. C. | 11 | 1831 |
18 | Planck M. | 18 | 1858 |