Re: Left join syntax error

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Left join syntax error
Date: 2024-05-18 15:40:09
Message-ID: 35e0eedd-94c-882c-c6f2-68f2b5b6331c@appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2024-05-18 15:41:26 Re: Left join syntax error
Previous Message Rich Shepard 2024-05-18 15:38:46 Re: Left join syntax error