学习多表连接查询

此实践的目标就是能够根据文字提示，完成商品属性表sh_goods_attr和商品属性值表sh_goods_attr_value的各种查询需求。

select a.sort sort1,a.name name1,b.sort sort2,b.name name2 from sh_goods_attr a join sh_goods_attr b on a.id=b.parent_id
where a.category_id=6 order by a.sort asc,b.sort asc;
select name,attr_value from sh_goods_attr s1,sh_goods_attr_value s2 where s1.id=5;
select attr_value from sh_goods_attr_value where attr_id in(select s2.id from sh_goods_attr s1,sh_goods_attr s2 where s1.id=1 and s1.id=s2.parent_id); 
Select id,name From sh_goods Where id In (Select goods_id From sh_goods_attr_value Group By goods_id Having Count(id)>1);