what is the difference between join keyword and inner join keyword in oracle sql? [duplicate]
- Following 1992 ANSI SQL reference, INNER is optional:
Query expressions 179 7.5 - joined table
3) If a qualified join is specified and a join type is not specified, then INNER is implicit.
- Following Oracle Standards (9i onward), the
INNER
prefix is also optional. Before 9i, Oracle didn't follow ANSI rules, and didn't even supportJOIN
syntax.