Hello,

Sorry for posting again.In the last message,by mistake i had written
"all the products under level 1".
I want all the products under level 0.

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 0 product.
I want this result.

33
45
22

How can i write a query for getting this result?

Thanks

Sivaraman