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

Gustav Brock gustav at cactus.dk
Tue Apr 27 14:34:10 CDT 2004


Hi Francisco

OK, thanks for the clarification.

/gustav


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




More information about the AccessD mailing list