# TDP 4.1 QueryBuilder Remove Join Issue

**URL:** <https://forums.toadworld.com/t/tdp-4-1-querybuilder-remove-join-issue/39070>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [February 13, 2017, 7:50am UTC](https://forums.toadworld.com/t/tdp-4-1-querybuilder-remove-join-issue/39070 "2017-02-13T07:50:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![TDP\_OWL](https://avatars.discourse-cdn.com/v4/letter/t/ce73a5/32.png) [@TDP\_OWL](https://forums.toadworld.com/u/TDP_OWL)\
**Post date:** [February 13, 2017, 7:50am UTC](https://forums.toadworld.com/t/tdp-4-1-querybuilder-remove-join-issue/39070/1 "2017-02-13T07:50:44Z")

</div>

I noticed an issue in QueryBuilder (one of my favorite feature of TDP) with removing JOINS. In the image below, I am joining two tables by two column names.

However, if I want to REMOVE the join tbl.tbl\_col3 = tbl\_1.tbl\_col3, the join tbl.tbl\_col1 = tb\_1l.tbl\_col1 is removed. Then when I click REMOVE again, the tbl.tbl\_col3 = tbl\_1.tbl\_col3 is removed.

I never seen this issue in TDP 3.7. Has anyone experienced this issue?

![Img1.png](https://global.discourse-cdn.com/quest/original/2X/8/88d0f3a504502dd45caaf008e70368871229f64a.png)

My second issue with QueryBuilder is that the single-click add/removes the columns to the SQL field window. Ideally, this should be a double-click function for better UX and to alleviate “accidental clicking”. Thoughts on this issue?

---

<div class="post-metadata">

**Author:** ![Libor.Witasek](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/libor.witasek/32/286_2.png) [@Libor.Witasek](https://forums.toadworld.com/u/Libor.Witasek)\
**Post date:** [February 13, 2017, 11:02pm UTC](https://forums.toadworld.com/t/tdp-4-1-querybuilder-remove-join-issue/39070/2 "2017-02-13T23:02:55Z")

</div>

Hello,

Thank you for your comment. I can confirm this is a bug. I’ve created QAT-9921 to fix this.

About the second issue: What about to add / remove the column only if user (single) clicks directly to the check-box rectangle, not to the whole row?

Libor

---

<div class="post-metadata">

**Author:** ![TDP\_OWL](https://avatars.discourse-cdn.com/v4/letter/t/ce73a5/32.png) [@TDP\_OWL](https://forums.toadworld.com/u/TDP_OWL)\
**Post date:** [February 14, 2017, 10:03am UTC](https://forums.toadworld.com/t/tdp-4-1-querybuilder-remove-join-issue/39070/3 "2017-02-14T10:03:28Z")

</div>

Thank you for the reply. The single-click to the check-box can work assuming that reducing the zoom to below 100% does not cause any GUI issues.