Not In / Not Exists

[hafa]

I'm attempting to find all records which are not in the results of a subquery; for example:

SELECT     *
FROM         tblnews
WHERE     (news_catID = 1) AND (NOT EXISTS
                          (SELECT     TOP 5 *
                            FROM          [tblnews]
                            WHERE      news_catID = 1
                            ORDER BY [news_pubdte] DESC, [news_priority] ASC))
ORDER BY news_pubdte DESC, news_priority

The idea here is to display all records which do not show up as a result of the query:

SELECT     TOP 5 *
                            FROM          [tblnews]
                            WHERE      news_catID = 1
                            ORDER BY [news_pubdte] DESC, [news_priority] ASC)

and have a news_catID of 1. The only problem is that the first query shown returns no records. I've also tried:

SELECT     *
FROM         tblnews
WHERE     (newsID NOT in
                          (SELECT     TOP 5 *
                            FROM          [tblnews]
                            WHERE      news_catID = 1
                            ORDER BY [news_pubdte] DESC, [news_priority] ASC))

But this returns the error: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

I think that there needs to be a combination of the two, but am unsure about how to go about it. Any help for a hopeless newbie would be appreciated.

[hafa]

OK, figured it out...

SELECT     *
FROM         tblnews
WHERE     (news_catID = 1) AND (newsID NOT IN
                          (SELECT     TOP 5 newsID
                            FROM          tblnews
                            WHERE      news_catID = 1
                            ORDER BY news_pubdte DESC, news_priority ASC))
ORDER BY news_pubdte DESC, news_priority

Helps to declare a primary key in the inner query...