sql出错

SQL code:

/*
table1
LH LB
table2
LH LB
现在我想更新tabl2 LB 条件是table1的LH =table2的LH
*/
update table2 set LB = LH.LB
from table1 LH inner join table2.LH on LH.LH = LH.LH

---

update table2 set LB = a.LB
from table1 a inner join table2 b on a.LH = b.LH

---

SQL code:
update table2 set LB = LH.LB
from table1 LH inner join table2 LH on LH.LH = LH.LH

---

SQL code:
update table2 set LB = A.LB
from table1 A inner join table2 B on A.LH = B.LH

---

SQL code:
update table2 set LB = LH.LB
from table1 LH1 inner join table2 LH2 on LH1.LH = LH2.LH

---

update table2 set LB = table1.LB
from table1 inner join table2 on table1.LH = table2.LH

---

update LH2 set LB = LH1.LB
from table1 LH1 inner join  table2 LH2 on LH1.LH = LH2.LH

---

是同样的字段名
取个别名就行、

---

字段名改改！看行不？