Left join |
![]() |
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 |