Mysql Query for finding products having color = red and size =s

I need a single query for finding products having where conditions on product's option like color=red and size=s in same database which you have provided.

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'

Sorry for creating confusion. The database is wa_ecommerce_db-8072013.zip which is downloaded from below mentioned link: http://www.webassist.com/tutorials/Free-eCommerce-MySQL-Database

Also I need both conditions for color & size and if we using same query mentioned below, then no result found as both id not in same row. However result is ProductID = 1

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' AND options.OptionName = 's'

your where condition should use OR:
WHERE options.OptionName = 'red' OR options.OptionName = 's'

I need intersection result, because i need s size products having color = red

i dont understand what you mean by "intersecting result", but in this case you need to use OR in the condition since it is one column that contains the value.

perhaps you mean that yo want to find results for a particular product ID?

in that case add another condition for the productsID
WHERE (options.OptionName = 'red' OR options.OptionName = 's') AND products.ProductID = 12

I want the another solution of result found using below mentioned query

SELECT
products.ProductId,
options.*,
GROUP_CONCAT(CONCAT_WS('-',options.OptionGroupID, options.OptionName)) as properties
FROM
products
INNER JOIN
productoptions on products.ProductID = productoptions.ProductID
INNER JOIN
options ON options.OptionID = productoptions.OptionID
GROUP BY
ProductId
HAVING
properties LIKE '%1-red%' AND properties LIKE '%2-S%';