Looking at the online docs for 14.10, in the SQL Syntax manual section describing the ANSI-style join syntax, I see that the "INNER" keyword is listed above the main path of the diagram, while the JOIN keyword is on the main path, and options such as LEFT and RIGHT are presented under the main path. Am I correct in assuming that INNER is the default, such that if a programmer specified "JOIN" with no other options, it would be treated as an INNER JOIN? I think I'm correct, but I would like to be able to point programmers to the official text stating that is the case.
For those who suggest that I should RTFM before posting such an elementary question, I did. Specifically this section, which states that before trying to use the diagrams, "it is helpful to read the syntax diagram section of the Introduction". The problem is, I cannot find an Introduction. The manual jumps straight into the Overview of SQL Syntax. I would expect the Introduction to precede the Overview. I've looked in the 12.10, 14.10, and 15.0 versions of the manual.
Perhaps an update to the documentation is in order? Either include the Introduction section in the online version, or move the syntax diagram section into the Overview?
------------------------------
mark collins
------------------------------