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: | Raw Message | Whole Thread | 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 |