您所在位置：主题：sql太难了，请大家帮帮我！
封神
[专家分：0] 发布于 2006-05-09 11:27:00
select distinct jno from spj表 as spj_1
where not exists
(
select * from spj表 as spj_2 where sno='s1'and not exists
(
[u]select * from spj表 as spj_3
where spj_3.pno=spj_2.pno and spj_3.jno=spj_1.jno[/u]
)
)
下划线的那句就不知道是什么意思了，请高手给小弟讲讲，谢谢！
[em10][em10][em10][em10][em10][em8][em8][em8][em8][em8]
where not exists
(
select * from spj表 as spj_2 where sno='s1'and not exists
(
[u]select * from spj表 as spj_3
where spj_3.pno=spj_2.pno and spj_3.jno=spj_1.jno[/u]
)
)
下划线的那句就不知道是什么意思了，请高手给小弟讲讲，谢谢！
[em10][em10][em10][em10][em10][em8][em8][em8][em8][em8]
