Hi all, I have two indexes, and I want to check whether the data from one index=a exists in the other index=b, and extract the data from the other index=a index=a
id
1
1
2
3
3
inde...
See more...
Hi all, I have two indexes, and I want to check whether the data from one index=a exists in the other index=b, and extract the data from the other index=a index=a
id
1
1
2
3
3
index=b
id,name1,name2
1,10,a1
1,9,a2
3,9,a1
4,10,a1
4,12,a2
i want the result=
id,name1,name2
1,10,a1
1,9,a2
3,9,a1 Anyone, have a good way to guide Thank you!