thanks > -----Message d'origine----- > > UPDATE PubW SET IdMythe=0 WHERE NOT( IdMythe IN (SELECT IdMythe FROM > > Mythe) ) > > This one 100% > > > UPDATE PubW SET IdMythe=0 WHERE IdMythe NOT IN (SELECT > IdMythe FROM Mythe) > > Also should work