04-20-2022 08:30 AM
I have table A and Table
Table A has below data
inv_name | inv_id |
1001A | 10000001 |
1002b | 10000001 |
AE-21F | 10000001 |
1004D | 10000002 |
UZ-WTS | 100000002 |
TableB
pr_id | sub_prd_id |
10000001 | 123456 |
10000001 | 23456 |
10000001 | 13456 |
10000001 | 121212 |
10000002 | 123456 |
10000002 | 23456 |
10000002 | 13456 |
10000002 | 121212 |
when i join table A(Child) with Table B(Parent) on inv_id = pr_id i'm getting i'm getting single parent record
inv_name | inv_id | pr_id | sub_prd_id |
AE-21F | 10000001 | 10000001 | 123456 |
how can i get all the sub_prd_id id details mapped each prd_name in incorta?
i'm getting it with materialised view , is there any other solution to achive it.
04-24-2022 10:48 AM
Thanks Suxinji for the solutions.
is there any possibility to do it with out Manual SQl?
what im looking is instead of using MV,Incorta_postges,incortaSql can we model the data(code free pipeline) to perform M:M relationship?