update kucun2 set shuliang=shuliang + b.shuliang
from kucun2 a inner join (select a.xilie_id,sum(shuliang) as shuliang from inserted group by xilie_id) b
on on a.xilie_id=b.xilie_idinsert kucun2(xilie_id,leibie_id,chanpinname,shuliang)
select xilie_id,leibie_id,chanpinname,shuliang from
inserted a left join kucun2 b
on a.xilie_id=b.xilie_id
where b.xilie_id is null
from kucun2 a inner join (select a.xilie_id,sum(shuliang) as shuliang from inserted group by xilie_id) b
on on a.xilie_id=b.xilie_idinsert kucun2(xilie_id,leibie_id,chanpinname,shuliang)
select xilie_id,leibie_id,chanpinname,shuliang from
inserted a left join kucun2 b
on a.xilie_id=b.xilie_id
where b.xilie_id is null
from kucun2 a inner join (select xilie_id,leibie_id,sum(shuliang) as shuliang from inserted group by xilie_id,leibie_id) b
on on a.xilie_id=b.xilie_id and a.leibie_id=b.leibie_idinsert kucun2(xilie_id,leibie_id,chanpinname,shuliang)
select xilie_id,leibie_id,chanpinname,shuliang from
inserted a left join kucun2 b
on a.xilie_id=b.xilie_id and a.leibie_id=b.leibie_id
where b.xilie_id is null
我试了您的方法,还是有出错了。提示说:ambiguous column name xilie_id,leibie_id
shuliang,chanpinname; the colunm prefix 'b' does not match with a table name ...