Grabbing empty group, sql query (join)

[SnowControl]

Heres the situation:

 

I have two tables, a newscategory table and a newsitem table. Each newsitem is connected to noe newscategory with a foreign key.

(simplified:)

NEWSITEM

newsitemID

newscategoryID*

newstext

 

NEWSCATEGORY

newscategoryID

categoryname

 

What i want to do, is to make a query that only lists the newscategory post that has 0 newsitem in them. And preferrably also a query that will for example list only those categories with more than 3 newsitems, exactly 5 newsitems etc etc (but i understand this would be harder).

 

Any idea how to accomplish this? I know i can process the results with PHP afterwards to get the desired results, but i was wondering if you could do it in the actual query.

[teng84]

SELECT * FROM NEWSITEM INNER JOIN newsitemID 0N newscategoryID WHERE newsitemID='0'

OR MAYBE THIS

SELECT * FROM NEWSITEM INNER JOIN newsitemID 0N newscategoryID GROUP BY newsitemID