Hi,
i have 2 indexes
index=abc & index=xyz
Index abc has following values
ID.......Type Name class Address
001....A.......Tejas....12A...India
002....A.......Jhon.....11A...USA
003....B.......Tom......11A...UK
004....C.......Ram......12B...India
004....A.......Ron......12B...UAE
Index XYZ has following values
ID.......Type Name class Address
001....A.......Tejas....12A...India
002....A.......Jhon.....11A...USA
004....D.......Ram......12B...India
004....A.......Ron......12B...UAE
It should return result where exact match found in both index for ID AND Type
Desired result
001....A.......Tejas....12A...India
002....A.......Jhon.....11A...USA
004....A.......Ron......12B...UAE
Thank you
index=abc [search index=xyz | dedup ID Type | fields ID Type]
also
index=abc | join type=inner max=0 ID Type [search index=xyz]
index=abc [search index=xyz | dedup ID Type | fields ID Type]
also
index=abc | join type=inner max=0 ID Type [search index=xyz]
Thanks for help