# Join two named queries?

**URL:** <https://forum.inductiveautomation.com/t/join-two-named-queries/19976>\
**Category:** Ignition\
**Created:** [October 4, 2018, 10:04am UTC](https://forum.inductiveautomation.com/t/join-two-named-queries/19976 "2018-10-04T10:04:10Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [October 3, 2024, 6:06pm UTC](https://forum.inductiveautomation.com/t/join-two-named-queries/19976/5 "2024-10-03T18:06:27Z")

</div>

Make some example datasets and post their CSVs here (from the dataset editor popup) in "preformatted text" code blocks. Then I can show you exactly what you need. But note, nowadays I do this exclusively in expressions using my (free) Integration Toolkit module:

> [@Automation Professionals' Integration Toolkit Module](https://forum.inductiveautomation.com/t/automation-professionals-integration-toolkit-module/74934/42):
>
> I had some dead time today. Party! Anyways, several new functions: alias() wraps a dataset with a string prefix for each column name nanoTime() just calls java's System.nanoTime() and returns the timestamp. crossJoin() does what you'd think with two datasets. innerJoin() takes two datasets, plus pairs of iterator expressions to match up. leftJoin() as for innerJoin(), but includes a null right row if a row on the left has no match on the right. For Ignition v8.1+: v2.0.6.232…

[https://www.automation-pros.com/toolkit/doc/datasets.html#leftjoin](https://www.automation-pros.com/toolkit/doc/datasets.html#leftjoin)

---

_[View the full topic](https://forum.inductiveautomation.com/t/join-two-named-queries/19976)._