# How to JOIN two tables on serperate databases?

**URL:** <https://forum.inductiveautomation.com/t/how-to-join-two-tables-on-serperate-databases/85115>\
**Category:** Ignition\
**Created:** [February 1, 2024, 7:11pm UTC](https://forum.inductiveautomation.com/t/how-to-join-two-tables-on-serperate-databases/85115 "2024-02-01T19:11:12Z")\
**Posts on this page:** 1\
**Showing post:** 4

<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:** [February 1, 2024, 8:07pm UTC](https://forum.inductiveautomation.com/t/how-to-join-two-tables-on-serperate-databases/85115/4 "2024-02-01T20:07:02Z")

</div>

You might find the various `join()` functions in my Integration Toolkit helpful.

> [@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…

---

_[View the full topic](https://forum.inductiveautomation.com/t/how-to-join-two-tables-on-serperate-databases/85115)._