Re: [SQL ] 如何下此update指令

[koehie (開喜烏龍茶)]

試試看!!

update a
set a.no = (select b.no from b where a.id = b.id)
where exists (select b.no from b where a.id = b.id)

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 118.233.168.82
推 mitsui0309:謝謝，我受用無窮