现有两个数据表：A（stu_id,name),B(id,stu_id),求A表中的stu_id不在B中的stu_id.求此SQL语句

[zhangqy]

现有两个数据表：A（stu_id,name),B(id,stu_id),求A表中的stu_id没在B中的出现的stu_id.求此SQL语句

[longji]

select stu_id from A where a.stu_id not in (select stu_id from B)

[pengdali]

select * form A where stu_id not in (select stu_id from B)

[gmlxf]

select stu_id from A where stu_id not in (select stu_id from B)

[pengdali]

打个补丁：

select * form A where stu_id not in (select stu_id from B where stu_id is not null)

[workhand]

select stu_id from A where stu_id not in (select distinct stu_id from B)

[zhangqy]

谢谢！