# Create complex queries in datagrid columns templates

**URL:** <https://forum.radzen.com/t/create-complex-queries-in-datagrid-columns-templates/528>\
**Category:** Uncategorized\
**Created:** [September 23, 2018, 11:19am UTC](https://forum.radzen.com/t/create-complex-queries-in-datagrid-columns-templates/528 "2018-09-23T11:19:03Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![enchev](https://forum.radzen.com/user_avatar/forum.radzen.com/enchev/32/16_2.png) [@enchev](https://forum.radzen.com/u/enchev)\
**Post date:** [September 24, 2018, 7:36pm UTC](https://forum.radzen.com/t/create-complex-queries-in-datagrid-columns-templates/528/5 "2018-09-24T19:36:12Z")

</div>

Hi,

You can also use nested expands (converted to JOINS in SQL) to present many-to-many like Orders -\> OrderDetails -\> Products:

 ![image](https://forum.radzen.com/uploads/default/original/1X/cb2d8de2a0afdf511712bcb299e21552f652d961.png)

 ![image](https://forum.radzen.com/uploads/default/original/1X/dbddf575009628efecb8179b6ecd70ed70fc8d64.png)

Here is [the application](https://drive.google.com/open?id=165HjtkgvNhC-u6PJk3pyEqibbfU8Qcuj).

Best Regards,  
Vladimir

---

_[View the full topic](https://forum.radzen.com/t/create-complex-queries-in-datagrid-columns-templates/528)._