I have a product hierarchy table. The product has 2 levels. At the first level, there is a TEAM assigned to it. The TEAM assigned at 1st level will handle its second level products as well. The display value for TEAM against second level data will be NULL. I want the same TEAM value that is handling first level data to be displayed even at the second level. I am attaching the sample data.
Can somebody please help me write the query for this...I am trying since long time but landed no where
Thanks
Lata.