34,588
社区成员
发帖
与我相关
我的任务
分享
/*添加测试数据*/
create table a(
id integer primary key not null,
num integer
);
insert into a (id, num) values (1, 3);
insert into a (id, num) values (2, 7);
insert into a (id, num) values (3, 5);
insert into a (id, num) values (4, 6);
insert into a (id, num) values (5, 23);
insert into a (id, num) values (6, 32);
create table b(
id integer primary key not null,
num1 integer
);
insert into b (id, num1) values (1, 3);
insert into b (id, num1) values (2, 7);
insert into b (id, num1) values (3, 5);
insert into b (id, num1) values (4, 6);
insert into b (id, num1) values (5, 23);
insert into b (id, num1) values (7, 45);
/*开始查询*/
select * from a where not exists(select * from b where a.id = b.id)
union all
select * from b where not exists(select * from a where a.id = b.id)
/* 输出结果
id num
6 32
7 45
*/