# Query builder - editing SQL code breaks query

**URL:** <https://forums.toadworld.com/t/query-builder-editing-sql-code-breaks-query/53039>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [June 16, 2021, 9:23am UTC](https://forums.toadworld.com/t/query-builder-editing-sql-code-breaks-query/53039 "2021-06-16T09:23:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![matt\_toad](https://avatars.discourse-cdn.com/v4/letter/m/7c8e57/32.png) [@matt\_toad](https://forums.toadworld.com/u/matt_toad)\
**Post date:** [June 16, 2021, 9:23am UTC](https://forums.toadworld.com/t/query-builder-editing-sql-code-breaks-query/53039/1 "2021-06-16T09:23:28Z")

</div>

Hi all,

I am currently using Toad Data Point 5.1.4.187 (64 bit) and have been struggling with the query builder tool.

My issue is that for some of the queries I build, I sometimes have to edit the joins to change the default inner joins to full outer joins. When I do this, I am asked to synchronize the query with the diagram. All fine, but my issue is then one of two things.

-The visualize query does nothing and does not update the diagram (the visualize query in 'query' tab stays green and does not disappear  
-The visualize does update the diagram but completely breaks the query (code typically becomes malformed after updating)

Before I go on, upgrading is not an option due to our company policy, but I was wondering if there is anything I can do to rectify this and avoid it happening. I'm quite new to SQL so writing from scratch isn't an option either. At the moment, I prefer to build the queries and edit them slightly but this clearly isn't working too well.

Any tips or is there some settings I can tweak? Also curious to understand why Toad defaults to inner joins? Presumably to save data load?

Thanks in advance,

Matt

---

<div class="post-metadata">

**Author:** ![Julie\_Hyman](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/julie_hyman/32/13709_2.png) [@Julie\_Hyman](https://forums.toadworld.com/u/Julie_Hyman)\
**Post date:** [July 1, 2021, 7:05pm UTC](https://forums.toadworld.com/t/query-builder-editing-sql-code-breaks-query/53039/2 "2021-07-01T19:05:02Z")

</div>

Hi Matt,

Improving the ability to edit the visual query from the SQL query tab and then resynching the visual without breaking it has been a focus of the Toad Data Point development team for the past couple of releases. I would suggest updating to the Toad Data Point 5.4 release and checking out this scenario in that version. There are still times where re-visualizing an edited query can be problematic but there have been significant strides in this area.