I have downloaded wa_ecommerce_db-8072013.zip
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'