Inner join

image

[ back ]


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


[ back ]