这个怎么分组查询?
字段
ID,name,Kind_A,Kind_B,Type_A,Type_B,Type_C
结构
Root
|
+-Type_a1
| |
| +-Type_b1
| | |
| | |-Type_c1
| | |-Type_c2
| | |-Type_c3
| | | :
| |
| +-Type_b2
| :
|
|
+-Type_a2
| |
| +-Type_b3
| :
----------------------
Root
|
+-Kind_a1
| |
| +-Kind_b1
| |
| +-Kind_b2
| :
+-Kind_a2
| :
分组规则
Type_a1
Kind_a1
Type_b1
Type_c1
Type_c2
:
Type_b2
:
Kind_a2
:
Type_a2
:
ID , name , Kind_A , Kind_B, Type_A, Type_B, Type_C
1 a Kind_a1 Kind_b1 Type_a1 Type_b1 Type_c..
2 b Kind_a2 Kind_b10 Type_a1 Type_b2 Type_c..
3 c Kind_a1 Kind_b2 Type_a2 Type_b10 Type_c..
7 d Kind_a1 Kind_b4 Type_a1 Type_b2 Type_c..
8 e Kind_a1 Kind_b7 Type_a3 Type_b100 Type_c.
9 f Kind_a2 Kind_b12 Type_a2 Type_b10 Type_c..
11 g Kind_a1 Kind_b2 Type_a1 Type_b7 Type_c..
我晕了,不知道说明白没有
谁帮我解决了,愿意出200