left/right join in query designer
delphi XE7 - RB 16.01 378
In query designer It seems there's a bug adding tables with join.
you can choose any join type ( left, right, full , inner ) but
resultant sql is always something like :
FROM TABLE1 TABLE1_1
, TABLE2 TABLE2_2
WHERE
(TABLE2_2.ID = TABLE1_1.ID)
i need classic left join but I can have it
( with rb15 , i'm sure to remmeber , it ran perfectly )
there's some know bug ?
thanks
In query designer It seems there's a bug adding tables with join.
you can choose any join type ( left, right, full , inner ) but
resultant sql is always something like :
FROM TABLE1 TABLE1_1
, TABLE2 TABLE2_2
WHERE
(TABLE2_2.ID = TABLE1_1.ID)
i need classic left join but I can have it

( with rb15 , i'm sure to remmeber , it ran perfectly )
there's some know bug ?
thanks
This discussion has been closed.
Comments
every time i open my rtm , i always should go to file , select
"database settngs" and reselect my db type and db name.
after doing this, query are made correctly!
thanks!
Nel suo scritto precedente, Diego Rigoni ha sostenuto :