| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Left join syntax error |
| Date: | 2024-05-18 12:52:34 |
| Message-ID: | 2c877258-61cc-dd2d-fac7-4f2a5c6293e7@appl-ecosys.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shammat | 2024-05-18 13:19:41 | Re: Left join syntax error |
| Previous Message | Julien Rouhaud | 2024-05-17 23:05:51 | Re: Execution history of a single query |