[V4MD] NOT IN

[Ruslan Zasukhin]

on 12/17/03 2:47 PM, Gregoire William at wgregoire at paris.mediagerance.com
wrote:

> 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) )

This one 100%

> and/or
> 
> UPDATE PubW SET IdMythe=0 WHERE IdMythe NOT IN (SELECT IdMythe FROM Mythe)

Also should work

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

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------