# Named query from multiple datasources

**URL:** <https://forum.inductiveautomation.com/t/named-query-from-multiple-datasources/39319>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [October 2, 2020, 5:33pm UTC](https://forum.inductiveautomation.com/t/named-query-from-multiple-datasources/39319 "2020-10-02T17:33:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![wpmccormick](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wpmccormick/32/13940_2.png) [@wpmccormick](https://forum.inductiveautomation.com/u/wpmccormick)\
**Post date:** [October 2, 2020, 5:33pm UTC](https://forum.inductiveautomation.com/t/named-query-from-multiple-datasources/39319/1 "2020-10-02T17:33:17Z")

</div>

Is it possible to to have named query that gets data from more than 1 datasource/gateway database? Do I just need to explicitly specify the datasource name in front of the table name?

If this is not possible, what the best way to combine data like this onto a single report?

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [October 2, 2020, 5:42pm UTC](https://forum.inductiveautomation.com/t/named-query-from-multiple-datasources/39319/2 "2020-10-02T17:42:37Z")

</div>

I don’t think you can hit up more than one data source in a Named Query. You would have to script it together.