HomeFlySpeed SQL Querynot getting outer join

not getting outer join


hi,

i have been playing with the tool lately and i found a little improvement/bug:

i was playing with outer joins in oracle and when did an outer join with tables from different schemas, the program processed the query not with an outer join but a criteria inside a field.

example:

from
...
siebel.tbl_lkp_hola hola
urseti.emepdi eme
...

where
...
hola.camp1(+) = eme.camp2


this condition in the where is not threated as an outer join.
Jordi | email
December 2 2010, 04:15 AM
The syntax of joins is determined according to the Oracle server version that you set in the connection properties. Please make sure that you set it right according to the version of Oracle server you are connecting to.
Sergey Smagin | email
4 days, 23 hours since original post
right.

the version i am using is Oracle 10G, and that is correct.

regards,
Jordi | email
5 days, 4 hours since original post
i got this error again: it is just that the program does not print correctly the joins (in this case outer left-right join)

example:

select hola.id_bu, em.id_em
from
siebel.hola
urseti.emepdi em
where
hola.camp1(+) = eme.camp2

i'll check if there is any new regarding that... it is a pitty because then you need to check criterias to find additional joins that were not printed in the visual part
Jordi | email
1 week, 3 days since original post
the correct query:

select hola.id_bu, em.id_em
from
siebel.hola
urseti.emepdi em
where
hola.camp1(+) = em.camp2
Jordi | email
1 week, 3 days since original post
Dear Jordi,

Can you provide the steps to reproduce this problem?
Sergey Smagin | email
1 week, 4 days since original post
hi Sergey

if you configure fly speed sql to connect to an Oracle 10G database, and then connect to a database in which the user has access to tables in different schemas.

then you copy paste the sql provided:

select hola.id_bu, em.id_em
from
siebel.hola
urseti.emepdi em
where
hola.camp1(+) = em.camp2

and finally you check the visual query printed by the program and that query is not printing the left join stated in the sql. (it puts in the criteria (like it is a filter) the join)

any other questions ask!
Jordi | email
1 week, 5 days since original post
Thank you for your explanation.

This problem will be fixed in the next minor version.
Sergey Smagin | email
1 week, 6 days since original post
thanks Sergey!

so you could identify the problem right?

i will be waiting for the version then
Jordi | email
1 week, 6 days since original post
Dear Jordi,

The problem is fixed in the new version of FlySpeed SQL Query. You may get it now from the tool home page.
Sergey Smagin | email
3 months since original post
This topic is closed