Query Designer/Syntax reverse SQL statement to diagram duplicates each tables columns.

[stanleylee]

When I use SQLeoVQB.2015.02.rc1_unlimited on my mac, each time try to reverse SQL statement to designer diagram, diagram tables show duplicated columns. Is this normal situation?
However, I use designer to drop table relation for SQL statement, this situation never happen.
Does anyone encounter the same situation like me?

[Anonymous]

Could you tell us which RDBMS/version you use,
and the form of the SQL query you try to reverse ?

[stanleylee]

I use Oracle 11g. Due to my company security policy, I cannot provide you original SQL statement.
Here is an example for reverse diagram.
SELECT a.*
FROM tab_a a, tab_b b
WHERE a.col1=b.col2

However, if I use below SQL statement, reversed diagram columns will not duplicate.
SELECT a.*
FROM tab_a a
INNER JOIN tab_b b
ON a.col1=b.col2

[PAscal]

could you try 2 solutions:
- retry reverse with option -- query builder -- use schema in syntax = no
- retry adding schema prefix to the tables : myschema.tab_a with option use schema in syntax = yes

[stanleylee]

I cannot find any place to setup syntax option. Could you tell me where it is?

[PAscal]

menu
tools -- preferences -- query builder
use schema name in syntax definition

[stanleylee]

After I change syntax option, whatever with schema name or not, program will transform equal join to inner join before reverse to diagram. In current situation, there is no duplicated columns shown in reversed diagram. Anyway my problem is solved.

Thanks your support.