Re: Left join syntax error

[Rich Shepard]

On Sat, 18 May 2024, Adrian Klaver wrote:

... LEFT JOIN companies as c ON c.company_nbr = p.company_nbr;

Adrian,

Tried that:
bustrac-# LEFT JOIN companies as c ON c.company_nbr = p.company_nbr;
ERROR:  table name "c" specified more than once

Thanks,

Rich