# Join tables in Omni Analytics

**URL:** <https://community.omni.co/t/join-tables-in-omni-analytics/159>\
**Category:** Modeling\
**Created:** [October 1, 2024, 6:43am UTC](https://community.omni.co/t/join-tables-in-omni-analytics/159 "2024-10-01T06:43:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tomer\_vision.bi](https://avatars.discourse-cdn.com/v4/letter/t/71c47a/32.png) [@Tomer\_vision.bi](https://community.omni.co/u/Tomer_vision.bi)\
**Post date:** [October 1, 2024, 6:43am UTC](https://community.omni.co/t/join-tables-in-omni-analytics/159/1 "2024-10-01T06:43:00Z")

</div>

Hi Omnis,  
I tried to do join between two tables,  
the join needs 3 keys in order to be unique, but each time the option is only join by 1 key.  
How I can solve this issue?

---

<div class="post-metadata">

**Author:** ![klawecki](https://avatars.discourse-cdn.com/v4/letter/k/779978/32.png) [@klawecki](https://community.omni.co/u/klawecki)\
**Post date:** [October 1, 2024, 10:13am UTC](https://community.omni.co/t/join-tables-in-omni-analytics/159/2 "2024-10-01T10:13:31Z")

</div>

See here:

> **[Relationships & Joins | Omni Analytics Documentation](https://docs.omni.co/docs/modeling/relationships)**
>
> Relationships describe how tables join together in SQL, and allow querying with dimensions and measures in different tables from the workbook UI. Relationships are all stored in a single model file.

tl;dr: you need to define the join in relationship file; see part on “Compound join keys” 🙂

 ![image](https://canada1.discourse-cdn.com/flex004/uploads/omni/original/1X/b2bdbc1fccbbfe3bd8976a5256e90454bad7467a.png)