# JOINing two tables in an INSERT INTO

**URL:** <https://forum.inductiveautomation.com/t/joining-two-tables-in-an-insert-into/110498>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [September 9, 2025, 6:24pm UTC](https://forum.inductiveautomation.com/t/joining-two-tables-in-an-insert-into/110498 "2025-09-09T18:24:38Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [September 9, 2025, 8:08pm UTC](https://forum.inductiveautomation.com/t/joining-two-tables-in-an-insert-into/110498/6 "2025-09-09T20:08:44Z")

</div>

> [@Chris\_Buehrer](#):
>
> reason code (real)

Is it actually a `REAL`? That's almost certainly not what you want. Just because a reason code happens to be something like `digits.digits`, doesn't mean you should represent it with REAL. If you do, then how do you distinguish between `123.1` and `123.10` and `123.100`?

---

_[View the full topic](https://forum.inductiveautomation.com/t/joining-two-tables-in-an-insert-into/110498)._