How do I select the rows of a table that don't match another table in SQL?

Question

I am trying to display all the names from the table vocabulary where the vids do not match a vid in collapse_menu. How would I do this?

Table vocabulary
    vid     name
    1   Sections
    2   Posts
    6   Forums
    5   Departments
    13  Free Tags
    8   Committees
    9   Training and Workshops
    10  Policies
    12  Projects
    14  Teams

Table collapse_menu
vid
8
5
10

Answer 1

select name from vocabulary as v, collapse_menu as c where v.vid!=c.vid Edit: Sorry, didn't read the question properly.

Answer 2

select name from vocubulary where vid not in (select vid from collapse_menu)

Answer 3

SELECT * FROM vocabulary, collapse_menu WHERE vocabulary.vid <> collapse_menu.vid;

Answer 4

I assume that you are asking for the those names in vocabulary, where the vid is not in the collapse_menu table.

In which case

SELECT name
FROM vocabulary
LEFT JOIN collapse_menu ON vocabulary.vid = collapse_menu.vid
WHERE collapse_menu.vid IS NULL