iran_sky
یک شنبه 08 خرداد 1390, 20:40 عصر
با سلام به دوستان
این دستورات چکاری انجام میدهند:
Select DISTINCT J#
From SPJ SPJX
Where not EXISTS
(Select * from SPJ SPJY
Where SPJY.J#=SPJX.J#
AND not EXISTS
(Select *
From SPJ SPJZ
Where SPJZ.P#=SPJY.p#
AND SPJZ.s#=’s1’));
این دستورات چکاری انجام میدهند:
Select DISTINCT J#
From SPJ SPJX
Where not EXISTS
(Select * from SPJ SPJY
Where SPJY.J#=SPJX.J#
AND not EXISTS
(Select *
From SPJ SPJZ
Where SPJZ.P#=SPJY.p#
AND SPJZ.s#=’s1’));