getting HIERARCHY data from a table

See more:

SQL-Server

hi,

for banking application , i need a query which retrive all the matched column data from bottom to top

i have tho tables

in table 1 i have

Group_Id    Group_Name            Primary_Group_Id
1            assets                    null  
2            liabilities               1
3            fixed                     2
4            expenses                  3
...

table 2

ID   Group_Id
948   3
955   2 

my requirement is , i will pass the ID=948 and i need to get the total HIERARCHY data from the bottom to top of
table 1

result: i want the following as output

ID   Group_Id  Group_Name  Primary_Group_Id  Group_Name    Group_Id  Group_Name
948  3         Fixed           2             liabilities    1        assets