find parent to which child

benaya · #1 (**permalink**) 11-10-08, 01:05

Hi,
I having table structure like
ID IBelong ID
1 0
2 0
3 1
4 3
5 2
6 4

I want to get values like parent record and their child and child's record also.

can anyone tell me the query how to build.

thanks in advance

healdem · #2 (**permalink**) 11-10-08, 05:47

Some guy called Limeback seems pretty knowledgeable in this area

r937 · #3 (**permalink**) 11-10-08, 06:28

the article Categories and Subcategories contains query examples

Internet Services

Web Development

Digital Marketing

Consumer Tech