Tuesday, January 10, 2017




Comparaison de 2 listes par SQL


Select Data
From
    (Select 'xxxxx' As Data union all
     ...
    Select 'xxxxx' As Data) as L1
Where L1.DI 
Not In
    (
        Select L2.Data
        From
           (Select 'xxxxx' As Data union all    
             ...
            Select 'xxxxx' As Data) as L2
     )

No comments:

Post a Comment