Re: Left join syntax error

[Rich Shepard <rshepard@xxxxxxxxxxxxxxx>]

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;

Thanks for the suggestion.

Regards,

Rich