# Toad Insight shows view syntax as invalid with outer join

**URL:** <https://forums.toadworld.com/t/toad-insight-shows-view-syntax-as-invalid-with-outer-join/40074>\
**Category:** Toad for Oracle - Beta\
**Created:** [October 6, 2017, 11:53am UTC](https://forums.toadworld.com/t/toad-insight-shows-view-syntax-as-invalid-with-outer-join/40074 "2017-10-06T11:53:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![rjesse](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/rjesse/32/156_2.png) [@rjesse](https://forums.toadworld.com/u/rjesse)\
**Post date:** [October 6, 2017, 11:53am UTC](https://forums.toadworld.com/t/toad-insight-shows-view-syntax-as-invalid-with-outer-join/40074/1 "2017-10-06T11:53:00Z")

</div>

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