How do I get subquery results

[bella]

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!

[ITWhisperer]

Try something like this

index=b [|search index=a | dedup id | table id | format]