Re: SQL question

The solution ?

delete from T DIST LIST TMP LIST1

    where

        (LIST1.NAME ID , LIST1.CONTACT ID) 
        in 
         (select LIST2.NAME ID, 
                 LIST2.CONTACT ID 
           from  T DIST LIST TMP LIST2 
           where DIST ID = P DIST ID 
           and   VER1.NAME ID = VER2.NAME ID 
           and   VER1.NAME CONTACT not like '%_at_%'); 

-- 
"Soyez sport, Donnez votre Sang !"
Etablissement Fran ais su Sang
0.801.150.150 ou 3614 Don du Sang
http://www.efs.sante.fr/frintro.html


  "Greg" <actiris_at_loxinfo.co.th> a  crit dans le message news: 
39BC53A9.D7D9FA24_at_loxinfo.co.th...
[Quoted]   I try to use this query 
      delete from T DIST LIST TMP LIST1 
      where LIST1.NAME ID 
        and LIST1.CONTACT ID in 
           (select LIST2.NAME ID, 
                   LIST2.CONTACT ID 
             from  T DIST LIST TMP LIST2 
             where DIST ID = P DIST ID 
             and   VER1.NAME ID = VER2.NAME ID 
             and   VER1.NAME CONTACT not like '%_at_%'); 


--