| From: | Vik Fearing <vik(at)postgresfriends(dot)org> |
|---|---|
| To: | max1(at)inbox(dot)ru, pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: INNER JOIN syntax is not commonly used? |
| Date: | 2021-03-07 11:45:46 |
| Message-ID: | b5bdc2dc-ceb4-52e9-2fc1-83b771829a2b@postgresfriends.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2021-03-07 12:05:43 | Re: INNER JOIN syntax is not commonly used? |
| Previous Message | Andrew Grillet | 2021-03-07 11:42:23 | Re: INNER JOIN syntax is not commonly used? |