Horton
Menu

Re: Left join syntax error

Rich Shepard <rshepard@appl-ecosys.com>

View thread
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@lists.postgresql.org
Date: 2024-05-18T15:04:13Z
Lists: pgsql-general 
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