Postgres Pro
Downloads
Home   >   mailing lists

Re: Left join syntax error - Mailing list pgsql-general

From Rich Shepard
Subject Re: Left join syntax error
Date
Msg-id e0c73ddb-a442-ddd8-c9b2-97e7a3e9123a@appl-ecosys.com
Whole thread Raw
In response to Re: Left join syntax error  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Left join syntax error
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Left join syntax error
Next
From: Ray O'Donnell
Date:
Subject: Re: Left join syntax error