"Nathan Sokalski" <njsokalski@hotmail.com> wrote in message
news:%23Ascz1KqHHA.1776@TK2MSFTNGP05.phx.gbl...
>I have an SQL query that is as follows:
>
> SELECT headline,url,summary,updated FROM worldnews EXCEPT (SELECT
> headline,url,summary,updated FROM worldnews WHERE newssection='Archives'
> UNION SELECT TOP 5 headline,url,summary,updated FROM worldnews WHERE
> newssection='Archives' UNION SELECT TOP 5 headline,url,summary,updated
> FROM worldnews WHERE newssection='Main') ORDER BY displayorder DESC
>
> When I test it using Microsoft Access 2003 it tells me there is a syntax
> error in the FROM clause. I tried executing everything inside the ()'s
> separately, which worked correctly, so I believe that the part causing the
> error is the EXCEPT keyword. Does Access not support the EXCEPT keyword (I
> am actually executing it through Jet using an ASP.NET application, but I
> designed the *.mdb file using Access 2003)? The ASP.NET application gives
> the following error:
>
> IErrorInfo.GetDescription failed with E_FAIL(0x80004005).
>
> The following query, which uses the same fields and tables, works with no
> problems:
>
> SELECT TOP 5 headline,url,summary,updated FROM worldnews WHERE
> newssection='Main' ORDER BY displayorder DESC
>
> Does anybody have any ideas what might be the problem? Thanks.
> --
> Nathan Sokalski
> njsokalski@hotmail.com
> http://www.nathansokalski.com/
>