Hello,

I have one field with 3 fields.

1)Sub_Prd_id 2)obj_prd_id 3)lvl_no.This is a hierarchy table.

Eg:

Sub_Prd_id Obj_Prd_id Lvl_no

21 21 0
21 33 1
33 45 2
45 22 3

Now i want all the products coming under level 1 product.
I want this result.

33
45
22

How can i write a query for getting this result?

Thanks

Sivaraman