Home DADE
New Blog Posts: Merging Reports - Part 1 and Part 2

left/right join in query designer

edited July 2015 in DADE
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

Comments

  • edited July 2015
    ok, i found the problem.
    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 :
This discussion has been closed.