Sorry

I have the right to change data structures have posted

sorry for making you hard

but actually the way you made did not meet my problem

can refer to the following example and continue to help me

in this example, I get all...

Please help me!!

this is DB i using.

You can setup it and re-check my case.

Thank for reply

In this DB, if i run with your idea

when ProductCategoryID=6, nothing show.

sorry! my english not good.

Select pav.ProductAttributeValueID,pc.CategoryName, pca.ProductCategoryAttributeName,pav.AttributeValue

From ProductAttributeValue pav

Inner Join...

Thank CirquedeSQLeil

your post is not true with my case

when ProductCategoryID=4

it must get all child of ProductCategoryID =4

but when i input ProductCategoryID = 4

it get only Mobile phone