infinitizon
MIS
Hi all,
I currently have a table with data in this format:
What I want now is a view to get the data in a child -parent relationship thus:
Any ideas please...
Thanks.
I currently have a table with data in this format:
SQL:
prd_id | prd_dsc | mdl_dsc
----------------------------------------------------------
001 | Regular Portfolio | Equities
001-CF-000001 | Fixed Income Fund | Funds
0002 | Managed Portfolio | Equities
001-NF-000374 | Ivory Fund | Funds
B1 | 90 Day Treasury Bills | Bills
SQL:
id | p_id | label
----------------------------
1 | null | Equities
2 | null | Funds
3 | null | Bills
4 | 1 | Regular Portfolio
5 | 2 | Fixed Income Fund
6 | 1 | Managed Portfolio
7 | 2 | Ivory Fund
8 | 3 | 90 Day Treasury Bills
Thanks.