On Sat, May 18, 2024 at 7:49 AM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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 = 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 = p.company_nbr;
... LEFT JOIN companies as c ON c.company_nbr = 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.
