多个left join的疑问

测试数据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