sql出错

[Andy_2010_]

/* 
  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

[xuam]

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

[--小F--]

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

[jiangshun]

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

[--小F--]

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

[Andy_2010_]

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

[tomyfolder]

字段名改改！看行不？