Devart Forums

1) Create a New Query
2) Select "Text" and copy this SQL code:

SELECT
table1.*, table2.*, table3.*
FROM
table1
Inner Join table2
Inner Join table3 ON
table2.id2 = table3.id3 ON table1.id1 = table3.id3

3) Select "Query Builder"
4) Select and Move a Table in the graph (for example table1)
5) Select "Text" and observe the code:

SELECT
table1.*, table2.*, table3.*
FROM
dbo.table1
Inner Join dbo.table2
Inner Join dbo.table3 ON
table2.id2 = table3.id3 AND table1.ID1 = table3.id3

The code is wrong and contains AND in place of ON

Could you please provide us the full name of the product along with its version?

A video or screenshots would be also of help.

You can send the reply straight to our support system at supportATdevartDOTcom.

OK
I have a video .AVI
but how I can insert a video in this forum?

P.S.: I send you an email with the video.

Here the video

The Product is this
=========================
General
=========================
Application: dbForge Studio 2021 for SQL Server
Product: Devart dbForge Studio 2021 for SQL Server
Product Edition: Enterprise
Product Locale: Italian
Assembly: dbforgesql, Version=6.0.470.0, Culture=neutral, PublicKeyToken=09af7300eec23701
C:\Program Files\Devart\dbForge Studio for SQL Server\dbforgesql.exe
Global cache: False
Framework: 4.7.2 or later

Thank you for the reply.

We were able to reproduce this issue and will fix it in one of the next product builds.

Thank you for your patience!
We would like to kindly inform you that we have released a new version of the tool. This version includes a lot of fixes.
You can upgrade to the new version within the app, just look on the bar on top for "Help->Check for updates".

Thanks I see that query builder dont'have this bug now
... but graphically it shows incorrectly only one inner join (and not two)

However I have an other problem, try this:

SELECT
table1.*
,table2.*
,table3.*
FROM dbo.table1
INNER JOIN dbo.table2
INNER JOIN dbo.table3
ON table2.id2 = table3.id3
ON table1.ID1 = table3.id3
UNION ALL
SELECT
table1.*
,table2.*
,table3.*
FROM dbo.table1
INNER JOIN dbo.table2
INNER JOIN dbo.table3
ON table2.id2 = table3.id3
ON table1.ID1 = table3.id3

I receive thes error message: "It is impossible to open Query Builder because either a query text is invalid, or the functionality of the edition you use is limited.
Do you want to continue editing the latest correct query?"

I'm using Enterprise Edition (trial) and this is only a simple UNION ALL of the same two queries !!!
I suggest you to correct this problem showing the two queries separately in the query builder and asking to the user what of the two query to edit!

UNION is not supported in dbForge. Though, you can vote for the following suggestion on the UserVoice forum
Query Builder Union Support

We collect and analyze the information from this forum in order to make a proper roadmap for the future product releases.

Hi Alexa,
I think this is a wrong approach to see the problem!

This is not a feature that needs to be rated, rather it is a bug to be fixed, because the UNION is a reserved word of the SQL syntax that needs to be implemented.

https://www.w3schools.com/sql/sql_ref_keywords.asp

If the visual query builder doesn't implement the UNION ... then it is wrong, it contains a bug!


P.S.: About the original bug... " graphically it shows incorrectly only one inner join (and not two)"

Thank you for the reply.

We will fix it in one of the next product builds and will notify you once it's available for downloading.