MySql查询出两张表中不同的数据

[_小生有礼了_]

表名:qqlist 和 qqlist2
字段 qq
qqlist: qqlist2
[qq] [qq]
155 155
215 215
355 355
444
555

两张表中qqlist2表多出两条记录 qq字段值为444,555
请问怎么查询出这几条记录?

[ACMAIN_CHM]

select * from t1 where q not in (select q from t2)

[mingqing6364]

qqlist有，qqlist2没有的：

SELECT * FROM qqlist WHERE NOT EXISTS (SELECT 1 FROM qqlist2 WHERE qqlist.qq = qqlist2.qq)

qqlist2有，qqlist没有的：

SELECT * FROM qqlist2 WHERE NOT EXISTS (SELECT 1 FROM qqlist1 WHERE qqlist.qq = qqlist2.qq)

[阿顾同学]

select qq from qqlist2 where  qq not in(select qq from qqlist);

答案如图：

[o前男友o]

create table qqlist(
id int AUTO_INCREMENT,
qq varchar(20) default '',
primary key(id)
);
create table qqlist2(
id int AUTO_INCREMENT,
qq varchar(20) default '',
primary key(id)
);
insert  into `qqlist`(`id`,`qq`) values (1,'155');
insert  into `qqlist`(`id`,`qq`) values (2,'215');
insert  into `qqlist`(`id`,`qq`) values (3,'355');
insert  into `qqlist`(`id`,`qq`) values (4,'111');
insert  into `qqlist2`(`id`,`qq`) values (1,'155');
insert  into `qqlist2`(`id`,`qq`) values (2,'215');
insert  into `qqlist2`(`id`,`qq`) values (3,'355');
insert  into `qqlist2`(`id`,`qq`) values (4,'444');
insert  into `qqlist2`(`id`,`qq`) values (5,'555');

select m,t.qq from 
(select 'qqlist' m,qq from qqlist 
union all 
select 'qqlist2' m,qq from qqlist2) t
where t.qq not in (select qq from qqlist a where exists (select * from qqlist2 b where b.qq=a.qq));