create trigger tg_tb_a_ins
on tb_a
for insert
as
begin
insert into tb_c(uid,sex,msg)
select distinct inserted.uid,inserted.sex,inserted.msg
from inserted,tb_b
where tb_b.uid=inserted.uid and tb_b.sex=inserted.sex
end
on tb_a
for insert
as
begin
insert into tb_c(uid,sex,msg)
select distinct inserted.uid,inserted.sex,inserted.msg
from inserted,tb_b
where tb_b.uid=inserted.uid and tb_b.sex=inserted.sex
end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货