Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1lIrr9-0007fV-Pk
	for pgsql-docs@arkaria.postgresql.org; Sun, 07 Mar 2021 11:45:55 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1lIrr8-0000o9-HF
	for pgsql-docs@arkaria.postgresql.org; Sun, 07 Mar 2021 11:45:54 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <vik@postgresfriends.org>)
	id 1lIrr8-0000o1-BZ
	for pgsql-docs@lists.postgresql.org; Sun, 07 Mar 2021 11:45:54 +0000
Received: from relay12.mail.gandi.net ([217.70.178.232])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <vik@postgresfriends.org>)
	id 1lIrr5-0002Py-Aj
	for pgsql-docs@lists.postgresql.org; Sun, 07 Mar 2021 11:45:53 +0000
Received: from [172.16.255.146] (14.149.88.79.rev.sfr.net [79.88.149.14])
	(Authenticated sender: vik@postgresfriends.org)
	by relay12.mail.gandi.net (Postfix) with ESMTPSA id A18FE200002;
	Sun,  7 Mar 2021 11:45:47 +0000 (UTC)
Subject: Re: INNER JOIN syntax is not commonly used?
To: max1@inbox.ru, pgsql-docs@lists.postgresql.org
References: <161510962276.1050.10968048440449352120@wrigleys.postgresql.org>
From: Vik Fearing <vik@postgresfriends.org>
Message-ID: <b5bdc2dc-ceb4-52e9-2fc1-83b771829a2b@postgresfriends.org>
Date: Sun, 7 Mar 2021 12:45:46 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.10.0
MIME-Version: 1.0
In-Reply-To: <161510962276.1050.10968048440449352120@wrigleys.postgresql.org>
Content-Type: text/plain; charset=utf-8
Content-Language: en-US
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Archived-At: 
 <https://www.postgresql.org/message-id/b5bdc2dc-ceb4-52e9-2fc1-83b771829a2b%40postgresfriends.org>
Precedence: bulk

On 3/7/21 10:33 AM, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
> 
> Page: https://www.postgresql.org/docs/13/tutorial-join.html
> Description:
> 
> This page shows a WHERE syntax to join tables.
> 
> After that it shows an example of the INNER JOIN syntax:
> SELECT *
>     FROM weather INNER JOIN cities ON (weather.city = cities.name);
> 
> And after that it says the following:
> "This syntax is not as commonly used as the one above, "
> 
> So, this documentation claims that the INNER JOIN syntax is not as common as
> WHERE syntax.
> Is this really the case?

I don't remember the last time I saw a new query use the <table
reference list> syntax.  In my experience, the <joined table> syntax is
much more common.  I vote to change the wording on that page.
-- 
Vik Fearing