SQL-Query: Existe dans la sous-carte

Select ...
From tabData As T1
Where Exists    (
                Select 1
                From tabDataDetail As TDD1
                Where TDD1.fiData = T1.idData
                    And TDD1.fiactionCode = 11
                )
    And Not Exists    (
                      Select 1
                      From tabDataDetail As TDD1
                      Where TDD1.fiData = T1.idData
                          And TDD1.fiactionCode Not In(11,34)
                    )
To expand on my logic, the first check (a correction) is to ensure that a row with fiActionCode = 11 exists. The second check works by first defining the set of rows we do not want. We do not want anything that is something other than fiActionCode = 11 or 34. Because that is the set of items we do not want, we search for anything that does not exist in that set.

EDIT: APOLS - Je vois ce que vous voulez dire avec des lignes d'enfants. Ce n'est pas particulièrement efficace. Merci également à Lieven pour les données.

SELECT idData FROM
tabData td
WHERE EXISTS 
(
    SELECT 1 
        FROM tabDataDetail tdd 
        WHERE tdd.fiData = td.idData AND fiActionCode = 11
 )
AND NOT EXISTS
(
    SELECT 1 
        FROM tabDataDetail tdd 
        WHERE tdd.fiData = td.idData AND fiActionCode <> 11
 )
UNION
SELECT idData 
    FROM tabData td
    WHERE EXISTS 
    (
        SELECT 1 
            FROM tabDataDetail tdd 
            WHERE tdd.fiData = td.idData AND fiActionCode = 11
     )
    AND EXISTS
    (
        SELECT 1 
            FROM tabDataDetail tdd 
            WHERE tdd.fiData = td.idData AND fiActionCode = 34
     )
AND NOT EXISTS
(
    SELECT 1 
        FROM tabDataDetail tdd 
        WHERE tdd.fiData = td.idData AND fiActionCode NOT IN (11, 34)
 )

raisonnement fort>

1. JOIN EXTÉRIEUR DE GAUCHE CODE> exclut tous les IDDATA qui ont une pièce d'identité différente de 11 ou 34 li>
2. avoir code> exclut tous les IDData que seul em> ont un 34 li>
3. Enregistrements restants (devrait) satisfaire toutes les contraintes li> ol>

   Données de test strong> p> xxx pré>

   Query strong> p>

   SELECT  *
   FROM    @tabData d
           INNER JOIN @tabDataDetail dd ON dd.fiData = d.idData
           INNER JOIN (
             SELECT  idData
             FROM    @tabData d
                     INNER JOIN @tabDataDetail dd ON dd.fiData = d.idData
                     LEFT OUTER JOIN (
                       SELECT  fiData
                       FROM    @tabDataDetail
                       WHERE   fiActionCode NOT IN (11, 34)
                     ) exclude ON exclude.fiData = d.idData
             WHERE   exclude.fiData IS NULL                
             GROUP BY
                     idData
             HAVING  MIN(fiActionCode) = 11        
           ) include ON include.idData = d.idData