Here's a "quick and dirty" way.
(Note: I used temp tables in my test. You'll have to mod accordingly)
SELECT Colors.[name]
FROM #FlowerColors FlowerColors
INNER JOIN #Colors Colors
ON FlowerColors.ColorID = Colors.ID
GROUP BY Colors.[name]
HAVING COUNT(DISTINCT...