Help Selecting from 1 table only records that match multiple records in another

[mikeathey]

I am having trouble writing an SQL statement to select all the records in Table-A that have multiple corresponding records in Table-B that meet a requirement.

Example:
names
id | name
1 | bob
2 | chris
3 | sam

favoritecolors
id | nameid | color
1 | 1 | blue
2 | 1 | yellow
3 | 2 | blue

I would like to select all the name records of people that like both blue AND yellow, not just blue OR yellow. So the output of the select should be the record for bob and nobody else.

I figure a join of some kind would be used but I can't quite figure it out.

This works if i'm only looking for people that like one color:

SELECT names.id, names.name FROM names JOIN favoritecolors ON names.id = favoritecolors.nameid WHERE favoritecolors.color = 'blue'

This is what i'm trying to do to get people that like 2 different colors but it's wrong:

SELECT names.id, names.name FROM names JOIN favoritecolors ON names.id = favoritecolors.nameid WHERE favoritecolors.color = 'blue' AND favoritecolors.color = 'yellow'

[r937]

SELECT n.name
  FROM `favorite-colors-table` AS f
INNER
  JOIN `names-table` AS n
    ON n.id = f.nameid
 WHERE f.color IN ( 'blue','yellow' )
GROUP
    BY n.name
HAVING COUNT(*) = 2