Hi, This is the case scenario: when I run this search query: index = "global" productID I get the following result: { "productID" : "12", "UserID" : "123_username", "type" : "web_based" }, .... I get 100s of these result with various productID's. Either same productID or different productID but I get the result that has productID in the entire index = "global" now the above query result have 2 key parameters that is of my interests. They are: productID UserID Now, I have 2 additional lookup table. They are: Employee_lookup {username, DepartmentName, .... } in the above query result: username == UserID Product_lookup {ProductID, ProductName, ... } in the above query result: ProductID == ProductID now my goal is to have one table that contains all the data, and my end result table will result with these columns: DepartmentName, ProductID, ProductName, UserID ---------------------------------------------------------------------------- Sales, 12, marketing, 123_username Business, 12, marketing, 323_username Business, 15, Online, 523_username Note that the ProductID and Product name are always same. All we are doing is fetching the ProductID, corresponding ProductName matching the ProductID, and then matching the UserID == Username, and related DepartmentName for the UserID... basically, I want to search all the ProductID along with its department name, product name, and userID How do I create a query for such end result? Could someone please help me?
... View more