SQL code
select goods_id attr_name attr_value attr_id
from
商品表 as t1
left join 属性表 as t2 on t1.goods_cate_id = t2.attr_cate_id
left join 属性表值对应表 as t3 on t2……
[/Quote]
SQL code
select goods_id attr_name attr_value attr_id
from
商品表 as t1
left join 属性表 as t2 on t1.goods_cate_id = t2.attr_cate_id
left join 属性表值对应表 as t3 on t2.attr_id = t3.goods……
[/Quote]
select c.goods_id,a.attr_name,c.attr_value,a1.attr_id from 属性表 a1 left join
(select a.*,b.goods_id,b.goods_cate_id from 商品属性值对应表 a inner join 商品表 b on a.goods_id=b.goods_id) c
on a1.attr_cate_id=c.goods_cate_id
select goods_id attr_name attr_value attr_id
from
商品表 as t1
left join 属性表 as t2 on t1.goods_cate_id = t2.attr_cate_id
left join 属性表值对应表 as t3 on t2.attr_id = t3.goods_attr_id