# Fetch record from Multiple Table Using Elastic Search Join Query in .net **URL:** \ **Category:** Elasticsearch\ **Created:** [March 3, 2017, 5:27am UTC](https://discuss.elastic.co/t/fetch-record-from-multiple-table-using-elastic-search-join-query-in-net/77263 "2017-03-03T05:27:25Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Rahul\_Saxena](https://avatars.discourse-cdn.com/v4/letter/r/7993a0/32.png) [@Rahul\_Saxena](https://discuss.elastic.co/u/Rahul_Saxena)\ **Post date:** [March 3, 2017, 5:27am UTC](https://discuss.elastic.co/t/fetch-record-from-multiple-table-using-elastic-search-join-query-in-net/77263/1 "2017-03-03T05:27:26Z")
We are implementing "Elastic Search" in our one of the project in .NET. We have already started the implementing. But somehow between it, we are facing some issues. We have transferred our SQL database to the Elastic Search's Database, and also we are getting records using it. But further, We wants to get records from multiple tables, and also want to make joins between them. But We are unable to find any tutorial/reference regarding this for Elastic Search. So can you please guide us how to make joins between tables in Elastic Search, and get records from multiple tables. Please help us into this concern, so we can go further with implementing Elastic Search into our Project. ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [March 3, 2017, 6:04am UTC](https://discuss.elastic.co/t/fetch-record-from-multiple-table-using-elastic-search-join-query-in-net/77263/2 "2017-03-03T06:04:55Z")
Elasticsearch is not a relational data store and does not support joins. You are therefore very likely to need to change how you model data when you move from a relational database. This often means denormalising the data, but there are a few other features that can help in certain circumstances. This is described [in the Elasticsearch - the Definitive Guide](https://www.elastic.co/guide/en/elasticsearch/guide/2.x/relations.html), which I would recommend reading. ---
**Author:** ![Rahul\_Saxena](https://avatars.discourse-cdn.com/v4/letter/r/7993a0/32.png) [@Rahul\_Saxena](https://discuss.elastic.co/u/Rahul_Saxena)\ **Post date:** [March 3, 2017, 6:55am UTC](https://discuss.elastic.co/t/fetch-record-from-multiple-table-using-elastic-search-join-query-in-net/77263/3 "2017-03-03T06:55:37Z")
WE are implementing the Elastic search in our .net project which is of nopCommerce 3.7(Open cart in .NET). In this, all the Stored Procedure and queries are predefined, and some are developed and customized by us. So it will become very time consuming and complex. So do you have any idea how we can implement the functionality of Elastic Search into nopCommerce 3.7? Can you please guide us how can we implement this type of functionality? Hope you know about nopCommerce, so you can guide us in better way. And thanks for your support. ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [March 3, 2017, 7:46am UTC](https://discuss.elastic.co/t/fetch-record-from-multiple-table-using-elastic-search-join-query-in-net/77263/4 "2017-03-03T07:46:04Z")
I know nothing about nopCommerce, so will only be able to provide general guidelines I am afraid. ---
**Author:** ![Rahul\_Saxena](https://avatars.discourse-cdn.com/v4/letter/r/7993a0/32.png) [@Rahul\_Saxena](https://discuss.elastic.co/u/Rahul_Saxena)\ **Post date:** [March 3, 2017, 9:37am UTC](https://discuss.elastic.co/t/fetch-record-from-multiple-table-using-elastic-search-join-query-in-net/77263/5 "2017-03-03T09:37:40Z")
Okay, Can you please provide me the demo code or sample file for this in c#/MVC? It will really appreciable... ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [March 3, 2017, 9:56am UTC](https://discuss.elastic.co/t/fetch-record-from-multiple-table-using-elastic-search-join-query-in-net/77263/6 "2017-03-03T09:56:35Z")
I am not a C# developer and have never heard of nopCommerce, so I will not be able to help with that. ---
**Author:** ![Rahul\_Saxena](https://avatars.discourse-cdn.com/v4/letter/r/7993a0/32.png) [@Rahul\_Saxena](https://discuss.elastic.co/u/Rahul_Saxena)\ **Post date:** [March 3, 2017, 11:13am UTC](https://discuss.elastic.co/t/fetch-record-from-multiple-table-using-elastic-search-join-query-in-net/77263/7 "2017-03-03T11:13:55Z")
Ok Thanks For Yout time ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [March 31, 2017, 11:13am UTC](https://discuss.elastic.co/t/fetch-record-from-multiple-table-using-elastic-search-join-query-in-net/77263/8 "2017-03-31T11:13:55Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.