MIME-Version: 1.0
References: <2c877258-61cc-dd2d-fac7-4f2a5c6293e7@appl-ecosys.com>
 <9d899286-3a73-4894-a6e0-eab529c92e65@gmx.net> <3216489-758a-faef-b21b-84c9679f53c@appl-ecosys.com>
 <acd229e3-ae27-45a9-808f-085bc1a0d1e5@aklaver.com>
In-Reply-To: <acd229e3-ae27-45a9-808f-085bc1a0d1e5@aklaver.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sat, 18 May 2024 08:27:19 -0700
Message-ID: <CAKFQuwYoRuZkkzA9AM14+qLGGzbtUmnbQr_y5=WqXmwrYPJ7UA@mail.gmail.com>
Subject: Re: Left join syntax error
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: Rich Shepard <rshepard@appl-ecosys.com>, pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000cf7f410618bc1cdc"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwYoRuZkkzA9AM14%2BqLGGzbtUmnbQr_y5%3DWqXmwrYPJ7UA%40mail.gmail.com>
Precedence: bulk

--000000000000cf7f410618bc1cdc
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sat, May 18, 2024 at 7:49=E2=80=AFAM Adrian Klaver <adrian.klaver@aklave=
r.com>
wrote:

> On 5/18/24 07:46, Rich Shepard wrote:
> > On Sat, 18 May 2024, Shammat wrote:
> >
> >> Don't put the second table in the FROM part
> >>
> >> SELECT p.lname, p.fname, p.job_title, p.company_nbr, p.email,
> >> c.company_name
> >> FROM people as p
> >>  LEFT JOIN companies as c ON c.company_nbr =3D p.company_nbr
> >
> > Shammat,
> >
> > I tried this with this result:
> >
> > ERROR:  missing FROM-clause entry for table "c"
> > LINE 3: LEFT JOIN companies ON c.company_nbr =3D p.company_nbr;
>
> ... LEFT JOIN companies as c ON c.company_nbr =3D p.company_nbr;
>
>
You failed at copy-and-paste.  If you use the exact query provided it will
indeed work.

If you want to explain why you thought writing in the company table twice
into the FROM clause of the query was a good idea maybe we can help you
unlearn that bad belief.  Otherwise feel free to just take the answer
you've been given.

David J.

--000000000000cf7f410618bc1cdc
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Sat, May 18, 2024 at 7:49=E2=80=AFAM Adrian Klaver &lt;=
<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@aklaver.com</a>&=
gt; wrote:</span><br></div></div><div class=3D"gmail_quote"><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid =
rgb(204,204,204);padding-left:1ex">On 5/18/24 07:46, Rich Shepard wrote:<br=
>
&gt; On Sat, 18 May 2024, Shammat wrote:<br>
&gt; <br>
&gt;&gt; Don&#39;t put the second table in the FROM part<br>
&gt;&gt;<br>
&gt;&gt; SELECT p.lname, p.fname, p.job_title, p.company_nbr, p.email, <br>
&gt;&gt; c.company_name<br>
&gt;&gt; FROM people as p<br>
&gt;&gt; =C2=A0LEFT JOIN companies as c ON c.company_nbr =3D p.company_nbr<=
br>
&gt; <br>
&gt; Shammat,<br>
&gt; <br>
&gt; I tried this with this result:<br>
&gt; <br>
&gt; ERROR:=C2=A0 missing FROM-clause entry for table &quot;c&quot;<br>
&gt; LINE 3: LEFT JOIN companies ON c.company_nbr =3D p.company_nbr;<br>
<br>
... LEFT JOIN companies as c ON c.company_nbr =3D p.company_nbr;<br><br></b=
lockquote><div><br></div><div class=3D"gmail_default" style=3D"font-family:=
arial,helvetica,sans-serif">You failed at copy-and-paste.=C2=A0 If you use =
the exact query provided it will indeed work.</div><div class=3D"gmail_defa=
ult" style=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">If you =
want to explain why you thought writing=C2=A0in the company table twice int=
o the FROM clause of the query was a good idea maybe we can help you unlear=
n that bad belief.=C2=A0 Otherwise feel free to just take the answer you=
9;ve been given.</div><div class=3D"gmail_default" style=3D"font-family:ari=
al,helvetica,sans-serif"><br></div><div class=3D"gmail_default" style=3D"fo=
nt-family:arial,helvetica,sans-serif">David J.</div><div class=3D"gmail_def=
ault" style=3D"font-family:arial,helvetica,sans-serif"><br></div></div></di=
v>

--000000000000cf7f410618bc1cdc--