Data Modeling

[Naruto]

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.

[Naruto]

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?