# Any way to form a join manually between tables when creating a data set?

**URL:** <https://community.amazonquick.com/t/any-way-to-form-a-join-manually-between-tables-when-creating-a-data-set/6223>\
**Category:** Q&A\
**Tags:** data-source, quick-sight\
**Created:** [September 22, 2022, 5:34pm UTC](https://community.amazonquick.com/t/any-way-to-form-a-join-manually-between-tables-when-creating-a-data-set/6223 "2022-09-22T17:34:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![obaranets](https://avatars.discourse-cdn.com/v4/letter/o/7ab992/32.png) [@obaranets](https://community.amazonquick.com/u/obaranets)\
**Post date:** [September 22, 2022, 5:34pm UTC](https://community.amazonquick.com/t/any-way-to-form-a-join-manually-between-tables-when-creating-a-data-set/6223/1 "2022-09-22T17:34:21Z")

</div>

Hi. Is there a way to form a join between “Reflexis” and “Calendar master” in addition to already existing join with “store master”? I know PowerBI allows to do something like this, does QuickSite have that kind of functionality? Looks like currently I can only connect “Reflexis” to “store master” OR “calendar master”… Any way to have both? Thanks.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/5/5a01ff4698d9a5189bb44d4029f50781248b6adc.png)

---

<div class="post-metadata">

**Author:** ![n\_vetri](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/n_vetri/32/2924_2.png) [@n\_vetri](https://community.amazonquick.com/u/n_vetri)\
**Post date:** [September 22, 2022, 9:02pm UTC](https://community.amazonquick.com/t/any-way-to-form-a-join-manually-between-tables-when-creating-a-data-set/6223/2 "2022-09-22T21:02:06Z")

</div>

Hi @obaranets  
Option 1: You can write customSQL if both tables are from the same data source  
[https://docs.aws.amazon.com/quicksight/latest/user/adding-a-SQL-query.html](https://docs.aws.amazon.com/quicksight/latest/user/adding-a-SQL-query.html)

Option 2: Please add the Reflexis again as another entity using Add Data button

Regards  
Vetri

---

<div class="post-metadata">

**Author:** ![Manohar\_Tammana](https://avatars.discourse-cdn.com/v4/letter/m/dfb087/32.png) [@Manohar\_Tammana](https://community.amazonquick.com/u/Manohar_Tammana)\
**Post date:** [November 8, 2022, 6:47pm UTC](https://community.amazonquick.com/t/any-way-to-form-a-join-manually-between-tables-when-creating-a-data-set/6223/3 "2022-11-08T18:47:28Z")

</div>

hey… I am new to Quicksight… I have a similar question like yours, but when we add new data, how to change join configuration with different tables? in my dataset, it is always relating to the same table