update yg2 inner join yg1 on yg1.xm=yg2.xm set yg2.hyh=yg1.hyh想加上条件yg1.tel=yg2.tel程序应该怎么写,update yg2 inner join yg1 on yg1.xm=yg2.xm,yg1.tel=yg2.tel set yg2.hyh=yg1.hyh
update yg2 inner join yg1 on yg1.xm=yg2.xm and yg1.tel=yg2.tel set yg2.hyh=yg1.hyh
update yg2 inner join yg1 on yg1.xm=yg2.xm set yg2.hyh=yg1.hyh where yg1.tel=yg2.tel
这3个都不对
update yg2 inner join yg1 on yg1.xm=yg2.xm and yg1.tel=yg2.tel set yg2.hyh=yg1.hyh
update yg2 inner join yg1 on yg1.xm=yg2.xm set yg2.hyh=yg1.hyh where yg1.tel=yg2.tel
这3个都不对
set yg2.hyh=yg1.hyh
from yg2 inner join yg1 on yg1.xm=yg2.xm and yg1.tel=yg2.tel
SET A.hyh=B.hyh
FROM yg2 AS A
JOIN yg1 AS B ON A.xm=B.xm
WHERE A.tel=B.tel
update yg2
set yg2.hyh=yg1.hyh
from yg2 inner join yg1 on yg1.xm=yg2.xm and yg1.tel=yg2.tel
也可以是
update yg2
set yg2.hyh=yg1.hyh
from yg2 inner join yg1 on yg1.xm=yg2.xm where yg1.tel=yg2.tel
1、update语句的正确写法
2、where和on的区别