On 5/18/24 08:04, Rich Shepard wrote:
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
Show the complete query.Take the error message as correct, you are specifying 'companies as c' more then once.
Thanks, Rich
-- Adrian Klaver adrian.kla...@aklaver.com
