Re: Left join syntax error

[Rich Shepard]

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