Hi!

If I am not mistaken, ansi joins are not supported by either query builder or beautifier. Do you have any plans of supporting it?

For example:

select *
from a join b on a.id = b.foreign_id
join c on a.c_id = c.id
where a.criteria = somevalue

1) Query builder does not let me choose if I want the ansi join or the other one

2) Beautifier makes the from one BIG line

Thanx.

Is that even legal in Oracle?

Yup it is in v9 and <, it's the new standard. The old way is still supported, I prefer the old way as it's so simple and neat but we gotta move with the times. We could start debating politics between sequel server and Oracle as this is their standard but they lets not get too sad or teckie.
Lorriane

We'll add support in 6.0.

Late reply to this thread...

Nice job adding ANSI Join support to the Beautifier. You're a step ahead of Quest Software's SQL/Navigator 4.0.3 in that regard.

Should the Query Builder also support it? If so, is that a feature I need to turn on? Version 6.0.2.880 doesn't recognized the JOIN statement, though it'll handle the Oracle syntax just fine.

I've just started checking out Developer a couple days ago, having used SQL/Navigator for about 3 hours every day for the past 3 years. So far, I'm VERY impressed in the comparison. I think Developer will make me a MUCH more productive programmer! Now I just have to convince my boss to spend the $$$! :-)

Thanks,

Stew

p.s. If someone at Allround wants to email me, I'd be happy to share what I see are advantages over SQL/Nav.

[quote]So far, I'm VERY impressed in the comparison. I think Developer will make me a MUCH more productive programmer! Now I just have to convince my boss to spend the $$$! :-)[/quote]Thanks . The Return On Investment time should be fairly short.

[quote]p.s. If someone at Allround wants to email me, I'd be happy to share what I see are advantages over SQL/Nav.[/quote]That is always useful to know. Perhaps you can e-mail me at marco.kalter@allroundautomations.com?

What about the query builder and ansi join ?

This will be added in a future PL/SQL Developer release, hopefully 6.1.