select * from (select * from Tb where 属性='颜色' and value='红色')a, (select * from Tb where 属性='尺码' and value='37')b, (select * from Tb where 属性='季节' and value='春季')c where a.商品=b.商品 and a.商品=c.商品
Select * from Table1 Where [属性] in('颜色','尺码','季节') And [值] In ('红色','37','春季')
select * from tb t where exists(select 1 from t where t.属性=颜色 and t.值=红色 and t.属性=尺码 and t.值=37 and t.属性=季节的 and t.值=春季)
Select * from Tb Where [属性] ='颜色' And [值]='红色' union all select * from tb where [属性] ='尺码' and [值]='37' union all select * from tb where [属性] ='季节' and [值]='春季'
Select * from Table1 Where [属性] in('颜色','尺码','季节') And [值] In ('红色','37','春季')
and t.值=红色 and t.属性=尺码 and t.值=37 and t.属性=季节的 and t.值=春季)
from Tb
Where [属性] ='颜色' And [值]='红色'
union all
select *
from tb
where [属性] ='尺码' and [值]='37'
union all
select *
from tb
where [属性] ='季节' and [值]='春季'