Update inner join的格式是:
update t1
set 字段=''
from t1
inner join t2 on t1.id = t2.tid
where t1.id = '123'
Delete inner join语句:
delete from t1
from t1
inner join t2 on t1.id = t2.tid
where t1.id = '123'
Update inner join的格式是:
update t1
set 字段=''
from t1
inner join t2 on t1.id = t2.tid
where t1.id = '123'
Delete inner join语句:
delete from t1
from t1
inner join t2 on t1.id = t2.tid
where t1.id = '123'