Excluding Multiple Records

[Anon]

I have a SELECT statement that pulls posting info from a forum. I want to exclude some of the forum_id's and I can exclude one no problem using:

SELECT topic_id, topic_title, forum_id WHERE forum_id != 16 ORDER...

So how do I exclude 2 forum_id's? I tried:

WHERE forum_id != 16 AND forum_id != 2

...but that is not logical I guess.

Thanks for any help.

Jim

[iifs044]

You could try using something like

SELECT *
FROM forum_table
WHERE forum_id NOT IN (3, 9, 42)