[V4MD] NOT IN

Gregoire William wgregoire at paris.mediagerance.com
Wed Dec 17 13:47:12 CST 2003


Hello!

can you tell me which of these syntax will work with Valentina 1.X ?

UPDATE PubW SET IdMythe=0 WHERE NOT( IdMythe IN (SELECT IdMythe FROM
Mythe) )

and/or

UPDATE PubW SET IdMythe=0 WHERE IdMythe NOT IN (SELECT IdMythe FROM Mythe)

sorry for the question, i just want to be sure :)


WilG



More information about the Valentina mailing list