1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
With ecoles As (Select 1 ECOLE_ID, 'école1' NOM From DUAL
Union All Select 2 ECOLE_ID, 'école2' NOM From DUAL
Union All Select 3 ECOLE_ID, 'école3' NOM From DUAL),
boites As (Select 1 BOITE_ID, 'VIP' NOM From DUAL
Union All Select 2 BOITE_ID, 'brasil' NOM From DUAL
Union All Select 3 BOITE_ID, 'boite3' NOM From DUAL),
soirees as (Select 1 SOIREE_ID, 1 BOITE, 1 ECOLE From DUAL
Union All Select 2, 2, 1 From DUAL
Union All Select 3, 3, 1 From DUAL
Union All Select 4, 1, 2 From DUAL
Union All Select 5, 2, 2 From DUAL
Union All Select 6, 1, 3 From DUAL
Union All Select 7, 3, 3 From DUAL)
Select E.NOM
From ECOLES E
Where Exists (Select 1 From BOITES B
Join SOIREES S On B.BOITE_ID = S.BOITE
Where E.ECOLE_ID = S.ECOLE And B.NOM = 'VIP')
And Not Exists (Select 1 From BOITES B
Join SOIREES S On B.BOITE_ID = S.BOITE
Where E.ECOLE_ID = S.ECOLE And B.NOM = 'brasil') |
Partager