Hello,
ich vermute, Du suchst einen Selfjoin in der Form als OUTER JOIN mit der Prüfung auf IS NULL.
*args* ich sollte genauer hingucken != ALL ist selbstverständlich was völlig anderes als = ALL.
MfG
Rouven
--
-------------------
sh:| fo:} ch:? rl:( br:& n4:{ ie:| mo:} va:) js:| de:] zu:| fl:( ss:) ls:& (SelfCode)
We found ourselves looking upon a familiar sight. We were home. How do you pick up the threads of an old life? How do you go on... when in your heart you begin to understand... there is no going back? There are somethings that time cannot mend... some hurts that go too deep... that have taken hold. -- The Lord of the Rings: The Return of the King (Peter Jackson)
-------------------
sh:| fo:} ch:? rl:( br:& n4:{ ie:| mo:} va:) js:| de:] zu:| fl:( ss:) ls:& (SelfCode)
We found ourselves looking upon a familiar sight. We were home. How do you pick up the threads of an old life? How do you go on... when in your heart you begin to understand... there is no going back? There are somethings that time cannot mend... some hurts that go too deep... that have taken hold. -- The Lord of the Rings: The Return of the King (Peter Jackson)