...least excruciating version of the relevant text...
Speaking of which, I had looked at the "From" section of the "SELECT" page (https://www.postgresql.org/docs/current/static/sql-select.html#SQL-FROM), which also has a somewhat detailed section on joins. I'm wondering about the utility of:
- Adding a link from the "SELECT" page (FROM section) to the page Tom referenced (which includes a link the other way)
and/or
- Adding this detail to the section on USING on the select page:
A clause of the form USING ( a, b, ... ) is shorthand for ON left_table.a = right_table.a AND left_table.b = right_table.b .... Also, USING implies that only one of each pair of equivalent columns will be included in the join output, not both. Outcome columns specified by USING will appear first in the joined results.
Cheers,
Ken