作者koehie (開喜烏龍茶)
看板Database
標題Re: [SQL ] 如何下此update指令
時間Sat Oct 22 00:38:32 2011
試試看!!
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
1F：推 mitsui0309:謝謝，我受用無窮 10/25 14:12