Left join

image

[ back ]


Select all records from list 1, along with records from list 2 for which the join condition is met (if at all). A left join returns all records from list 1 and any matching records from list 2.

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


Left-joined lists

ID Name ID Birth year
15 Bohr N.
13 Helmholtz H. 13 1883
11 Maxwell J. C. 11 1831
18 Planck M. 18 1858


[ back ]