Re: Left join syntax error

[Rich Shepard <rshepard@xxxxxxxxxxxxxxx>]

On Sat, 18 May 2024, Ray O'Donnell wrote:

> Look again at Shammat's example! -
>
> 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
>
> NB - "... from people as p left join companies as c on ...." - i.e. the 
> companies table (or its alias c) is only specified once.

Ray,

Yes, I did mis-read that.

Many thanks,

Rich