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