[SQL bzw. TSQL] Komplizierte SQL Anweisung

[omata]

SQL-Code:

SELECT company, nr, description
FROM mytable x
WHERE company = 40
   OR (    company = 60
       AND NOT EXISTS (SELECT * 
                       FROM mytable
                       WHERE company = 40
                         AND nr = x.nr))