[AccessD] Query fails when using NOT IN ???

Gustav Brock said the following on 4/23/2004 1:41 AM:

>But Christopher didn't refer to SQL Server, that's why I thought it
>would be more relevant to show that this bug is non-existing in Jet SQL.
>  
>
The reason this is even mentioned is because the IN bug is not a SQL 
Server bug at all but an ANSI SQL standard behavior and is even 
mentioned in a KB article here
http://support.microsoft.com/default.aspx?scid=kb;en-us;298674
or (http://tinyurl.com/35zgr)

>Further, I guess including the where clause will perform much slower?
>If you really need to do that, couldn't this do (I have no SQL Server
>to play with):
>
>     au_id IN
>     (SELECT au_id FROM Publishers WHERE Publishers.au_id Is Not Null)
>
>/gustav
>
>
>  
>
also accoring to the article fully qualifying the column name clears 
this problem up, which I tested and confirmed.

-- 
-Francisco