Tree Query Problem

Dear Kalman,

Thanks for your reply.

I must use materialized path 1 1.1 1.2 and etc because I got the data from CAD software BOM