mysql - 联接后显示表的所有行

我想从表B的匹配列中加入元素后显示表A的所有行

表A

+-----------+----------+------------+
| FirstName | LastName |    Date    |
+-----------+----------+------------+
| Tia       | Carrera  | 1975-09-18 |
| Nikki     | Taylor   | 1972-03-04 |
| Yamila    | Diaz     | 1970-03-05 |
+-----------+----------+------------+

表B

+-----------+------------+
|    code   | Date       |
+-----------+------------+
| 1234      | 1975-09-18 |
| 56789     | 1972-03-04 |
| 54856     | 1968-07-14 |
+-----------+------------+

我在网上找到的一切看起来像

+-----------+----------+------------+-----------+
| FirstName | LastName |    Date    |    code   |
+-----------+----------+------------+-----------+
| Tia       | Carrera  | 1975-09-18 | 1234      |
| Nikki     | Taylor   | 1972-03-04 | 56789     |
+-----------+----------+------------+-----------+

但这是我想要的结果

+-----------+----------+------------+-----------+
| FirstName | LastName |    Date    |    code   |
+-----------+----------+------------+-----------+
| Tia       | Carrera  | 1975-09-18 | 1234      |
| Nikki     | Taylor   | 1972-03-04 | 56789     |
| Yamila    | Diaz     | 1970-03-05 |           |
+-----------+----------+------------+-----------+

最佳答案

您需要一个left join：

select a.*, b.code
from a left join
     b
     on a.date = b.date;

关于mysql - 联接后显示表的所有行，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/45616278/