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