在Update 和 Delete语句中使用 Inner Join

update的格式是:

update table1

set table1.name=’abc’

from table1 

inner join table2

on table1.id = table2.id

where table2.number = '123'

 

delete 的格式是:

delete from table1

from table1

inner join table2

on table1.id = table2.id

注意蓝色部分，这样就可以省掉复杂的中间表了^_^

转载于:https://www.cnblogs.com/litsword/archive/2011/10/14/2211129.html