Why is the self join syntax so strange?

Why is the self join syntax so strange?

search resultssql - Why is the self join syntax so strange? - Stack Overflow
I repeat a student question here. I've given some sort of explanation, but
hoping you have better, clearer ones. A self-join is done with two aliases
for the table:
stackoverflow.com/.../why-is-the-self-​join-syntax-so-strange - Cached

Join (SQL) - Wikipedia, the free encyclopedia
Sample tables|Cross join|Inner join|Outer join5 Self- join. 5.1 Example; 6
Merge rows. 6.1 MySQL; ... The columns used in the join are implicit so
the join code does not show which columns are expected, ... syntax ...
en.wikipedia.org/wiki/Join_(SQL) - CachedMore results from
en.wikipedia.org »Joins
Self Joins . A self join is a join ... Oracle recommends that you use the
FROM clause OUTER JOIN syntax rather than ... operator must be applied to
the column so that ...
download.oracle.com/docs/cd/B19306_01/​server.102/b14200/... - Cached

Please use ANSI join syntax | Oracle FAQ - Welcome to The ...
The old Oracle join syntax really should be consigned to history. ...
should use the ANSI syntax. It is so much easier to read and ... Why add
another concept to the ...
www.orafaq.com/node/2618 - Cached

Joins
A self join is a join of a ... formed using the query_partition_clause of
the join_clause syntax. ... to the column so that Oracle returns the rows
from table A ...
download.oracle.com/docs/cd/B14117_01/​server.101/b10759/... - Cached

Main/Strange Syntax Speaker - Television Tropes & Idioms
The Strange Syntax Speaker trope as ... When doing so they use
then-now-next strange ... Give grace that the examples ended the trope's
strange self ...
tvtropes.org/pmwiki/pmwiki.php/Main/​StrangeSyntaxSpeaker - Cached

Ask Tom "join example, new vs old syntax"
looks strange indeed ... November 30, ... it isn't a JOIN, it is a FILTER.
So why "besides", ... Can I use new join syntax with self join? June 13,
2008 ...
asktom.oracle.com/pls/asktom/​f?p=100:11:0::::P11... - Cached

SQL Joins - W3Schools Online Web Tutorials
sql home sql intro sql syntax sql select sql select distinct sql where sql
and & or sql order by sql insert into sql update sql delete sql advanced
... left join ...
www.w3schools.com/sql/sql_join.asp - Cached

T-SQL for Starters: Data Retrieval with Joins | T-SQL content ...
Here's one reason why the ANSI syntax ... The question is whether this
null is really data from the inner table or whether the join inserted it.
So ... Self Joins Do ...
sqlmag.com/t-sql/t-sql-starters-data-​retrieval-joins - Cached

Self-joins - MySQL - Open Source Web Development Tutorials ...
The self-join provides the ... so we will correlate all ... Try playing
around with variations of the commands highlighted within this article to
gain a clear ...
www.devshed.com/c/a/MySQL/MySQL-Table-​Joins/4 - Cached