The structure of the table "testtable" is
id int primary key
where productid is the unique id of a product,
attributeid is the unique id of attribute of a product e.g. size, quality,height, color
and 'value' is the value for the attribute
i have to filter a result. I achieve the requirement by this query.
But i am not able to make it in a query.
select a.* from dbo.testtable a where a.attributeId=10 and a.[Value]='Romance' and productId in ( select productId from dbo.testtable where attributeId =7 and [Value]='Hindi' )
Need help to build this query..