用一表更新或删除另一表

插入的操作都很熟悉,但更新及删除的操作却很少用.

其实用inner join 来做的话是比较方便的.

更新:update a set address=b.address from a inner join b on a.name=b.name

access:

update aaa as a innner join bbb as b on a.name=b.name set a.address=b.address where b.name='aaa'

(是不是有点bt)

删除:delete from a from a inner join b on a.name=b.name