cancel
Showing results for 
Search instead for 
Did you mean: 

Data Modeling

Naruto
Partner
Partner

I have table A and Table

Table A has below data    

inv_nameinv_id
1001A10000001
1002b10000001
AE-21F10000001
1004D10000002
UZ-WTS100000002

    TableB

pr_idsub_prd_id
10000001123456
1000000123456
1000000113456
10000001121212
10000002123456
1000000223456
1000000213456
10000002121212

 

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_nameinv_idpr_idsub_prd_id
AE-21F1000000110000001123456

 

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.

 

5 REPLIES 5

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?