Re: [SQL ] 如何下此update指令
試試看!!
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
推
10/25 14:12, , 1F
10/25 14:12, 1F
討論串 (同標題文章)
完整討論串 (本文為第 2 之 2 篇)：