I want to join below 3 tables:
Table 1 has 621 total records in real time. I want to get all columns from Table 1
|
Id
|
Ute_Nm
|
Ute_Name
|
Ein_Nm
|
DeletedFlag
|
DateTime
|
|
6872
|
500001
|
AA
|
01025
|
0
|
|
|
6349
|
500002
|
BB
|
01026
|
0
|
|
|
6616
|
500003
|
CC
|
01028
|
0
|
|
|
6873
|
500004
|
DD
|
01032
|
0
|
|
|
6271
|
500005
|
EE
|
00104
|
0
|
|
Table 2 has 2391 total records in real time. I want to get only MK1,MK2,MK3 columns from table 2 in format: MK1/MK2/MK3
|
Id
|
Grn_Nm
|
Grn_Name
|
Ein_Nm
|
DeletedFlag
|
MK1
|
MK2
|
MK3
|
DateTime
|
|
35251
|
1317
|
A
|
01025
|
0
|
17
|
1
|
0
|
|
|
35252
|
1318
|
B
|
01026
|
0
|
5402
|
61
|
1
|
|
|
36599
|
9088
|
C
|
01026
|
0
|
23
|
3
|
12
|
|
|
36604
|
9098
|
D
|
03455
|
0
|
457
|
8
|
0
|
|
|
34546
|
12817
|
E
|
01028
|
0
|
1145
|
780
|
0432
|
|
|
38988
|
14083
|
F
|
01028
|
0
|
054
|
34
|
6286
|
|
|
33232
|
9025
|
G
|
01032
|
0
|
45
|
2356
|
45
|
|
|
34346
|
165
|
H
|
00104
|
0
|
7
|
33435
|
2
|
|
Table 3 has 1451 total records in real time. Where many Grn_Nm is connected to 1 Ute_Nm
|
Ute_Nm
|
Grn_Nm
|
DeletedFlag
|
|
500001
|
1317
|
Null
|
|
500002
|
1318
|
Null
|
|
500002
|
9088
|
Null
|
|
500002
|
9098
|
Null
|
|
500003
|
12817
|
Null
|
|
500003
|
14083
|
Null
|
|
500004
|
9025
|
Null
|
|
500005
|
165
|
Null
|
NOTE: Upon joining 3 tables and as we have many Grn_Nm connected to 1 Ute_Nm, I have to make a comma separated string as below:
MK1/MK2/MK3,MK1/MK2/MK3,MK1/MK2/MK3…
