oracle的“不满足”某个条件该怎么写

Question

比如，我想写一个语句
insert into t1(t1.a,t1.b)
select (t2.a,t2.b) from t2 “不满足”
(t2.a=t1.a and t2.b=t1.b);
以上，求大神解惑。

Answer 1

参照下这个
insert into student(sname,sage) select t2.cname,t2.cid from course t2 where not exists
(select 1 from student t1 where t1.sname = t2.cname and t1.sage = t2.cid);