mysql Insert from left join where 字段匹配

Question

我正在尝试将表 2 中的值插入到表 1，其中地址 B 与地址 A 匹配。到目前为止，我的尝试是下面的代码。查询似乎将新的空白记录插入到 table1 而不是我想要它做的。有人可以告诉我这个查询是否正确吗？

INSERT INTO database1.table1 (name)
select database2.table2.distName
from database2.table2
left join database1.table1
On database2.table2.addressB = database1.table1.addressA
where database2.table2.addressB = database1.table1.addressA

我的 sql fiddle

http://sqlfiddle.com/#!9/aca3e/2

Answer 1

INSERT INTO database1.table1 (name)
select database2.table2.a_distName2
from database2.table2
left join database1.table1
On database2.table2.addressB = database1.table1.addressA
where database1.table1.addressA is null;