Re: Left join syntax error

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

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;

> Thanks for the suggestion.
>
> Regards,
>
> Rich

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx