Toad World® Forums

Toad Insight shows view syntax as invalid with outer join

Howdy!

In the Edior on 12.12.0.29, I have this:

create or replace view test_view as select t.abc, u.def from tablet t outer join tableu u

But Toad Insight doesn’t like the word “join” here, where expects the keyword “APPLY”. If I remove the “t” table alias, it doesn’t like the word “outer”, saying I shouldn’t use a reserved word as a table alias.

The statement (it’s real-life counterpart) executes fine.

Thanks!
Rich