In the Edior on 126.96.36.199, 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.