When you say:
"in same database which you have provided."
are you referring to the eCommerce database? There are a number of different databases we have provided over the years, so just want to be specific.
if using the eCommerce database, the query would be:
SELECT products.ProductID,options.* FROM Products
INNER JOIN productoptions on Products.ProductID = productoptions.ProductID
INNER JOIN options ON options.OptionID = productoptions.OptionID
WHERE options.OptionName = 'red' OR options.OptionName = 'yellow'