Date: Sat, 18 May 2024 05:52:34 -0700 (PDT)
From: Rich Shepard <rshepard@appl-ecosys.com>
Reply-To: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@lists.postgresql.org
Subject: Left join syntax error
Message-ID: <2c877258-61cc-dd2d-fac7-4f2a5c6293e7@appl-ecosys.com>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset=US-ASCII
Archived-At: <https://www.postgresql.org/message-id/2c877258-61cc-dd2d-fac7-4f2a5c6293e7%40appl-ecosys.com>
Precedence: bulk

It's been a _very_ long time since I wrote a SQL script and, despite looking
at my SQL books and web pages, I don't know how to fix the error.

The three line script is:
-----
SELECT p.lname, p.fname, p.job_title, p.company_nbr, p.email, c.company_name
   FROM people as p, companies as c
LEFT JOIN companies ON c.company_nbr = p.company_nbr;
-----

and psql responds:
ERROR:  invalid reference to FROM-clause entry for table "p"
LINE 3: LEFT JOIN companies ON c.company_nbr = p.company_nbr;
                                                ^
HINT:  There is an entry for table "p", but it cannot be referenced from this part of the query.

Please show me what I've done incorrectly.

TIA,

Rich