Hi

we have foll columns ina out PBANk table

pbankname pbankparentcode pbankcode
aaa -1 101
bbb 101 201
ccc 101 202
ddd 101 203
eee -1 501
sss 501 333
qqq 501 121

bankcode are bracnhes whose parent are pbankparentcode .
-1 in pbamkparentcode indicates that it is parent bank.

i want an output something like this

pbankname (branch) pbanmcode(branch) pbankcode(parent) pbankname(parent)



Regards