测试数据a表id1-10,b表id5-12,c表id2-11
目的:找到满足a表不满足b表满足c表的id(应该是2,3,4)
use test;
create table testtesta (id bigint);
insert into testtesta values (1);
insert into testtesta values (2);
insert into testtesta values (3);
insert into testtesta values (4);
insert into testtesta values (5);
insert into testtesta values (6);
insert into testtesta values (7);
insert into testtesta values (8);
insert into testtesta values (9);
insert into testtesta values (10);
create table testtestb (id bigint);
insert into testtestb values (5);
insert into testtestb values (6);
insert into testtestb values (7);
insert into testtestb values (8);
insert into testtestb values (9);
insert into testtestb values (10);
insert into testtestb values (11);
insert into testtestb values (12);
create table testtestc (id bigint);
insert into testtestc values (2);
insert into testtestc values (3);
insert into testtestc values (4);
insert into