Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s8LjC-00ByLD-HS for pgsql-general@arkaria.postgresql.org; Sat, 18 May 2024 15:12:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s8LjB-007TyD-QF for pgsql-general@arkaria.postgresql.org; Sat, 18 May 2024 15:12:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s8LjB-007Ty4-FC for pgsql-general@lists.postgresql.org; Sat, 18 May 2024 15:12:05 +0000 Received: from fout6-smtp.messagingengine.com ([103.168.172.149]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s8Lj8-000tS5-CB for pgsql-general@lists.postgresql.org; Sat, 18 May 2024 15:12:04 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailfout.nyi.internal (Postfix) with ESMTP id 8EF4B138012D; Sat, 18 May 2024 11:12:01 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Sat, 18 May 2024 11:12:01 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1716045121; x=1716131521; bh=n3bfJ7K28zH7Hwj06RzPPJltj/FrV03sNIIPb3ZdMII=; b= mYOEVz/N8AM2xRY83h4k8uwVnKAAZuTMCKAg74CfUfJpHhsV7SuiKWRhW3mEx9pb VY4ogYjYdhQ/aDRM+OFtOL7VRaqwuGP8qmhH/rzUrBC8vkTe+0Fd8NsauU25yku4 jY5zyfNUaE7q4GVKyTlwHTFVvWJlUvqqMpG/fLo1nyZxw/zHVolHEEI4DwgW4S9r Tj5NzjpRxXBEd3UO82P0N/vEzOxnlhQ9mEH2C6saVA05n+3H32IcGMdO1XYVaNGc ZMEQ4GGABzIa0KVmSc6AKW8ud97DouehGkm/D4wE+jyvtyTG2K50MXrDEPcwcCZU 3lm9lawv3oih/Ucf18BoAw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1716045121; x= 1716131521; bh=n3bfJ7K28zH7Hwj06RzPPJltj/FrV03sNIIPb3ZdMII=; b=o EaBBbAREcgUcbQnwOjq+8c5ca0/fUFoCNr/BICNXTx4tcdZNhsdKp0lmsOX5GSpM UCHfSDDhGObnAhBSRfeKV+Pe9KT+2w+BNKF4iqNJ22G1nI+YBD7Ngm40SYc4Om6q eXyfMduKJREzXpqQ448kuXmLeztNH2hSVPiXyl8ukG4e7TCFIS4XWJzlG1sFShXi Zgn+xf9BxwAV97NUnL710RI4F0IooSCnMAFpnIMCMTCzcqirauT1L+LtyQKyhHNj 4/Blg9JOeEWjWdZx0WCd4jUlEF/VwReGQgHzkcWc+HaZYbvDOXm+yzFZ1tX7Sn+h hG0nFzJNZUnM+pH8KgTtg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrvdehiedgieekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvfhfhjggtgfesthekredttddvjeenucfhrhhomheptegurhhi rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh hmqeenucggtffrrghtthgvrhhnpeffleegieefgfevudehtdfhkeeutdffjeevgeffgeej vedthefgudeiteefheejheenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmh grihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 18 May 2024 11:12:00 -0400 (EDT) Message-ID: <9ef5ff57-34d2-43f5-99ca-6390d899a3f7@aklaver.com> Date: Sat, 18 May 2024 08:12:00 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Left join syntax error To: Rich Shepard , pgsql-general@lists.postgresql.org References: <2c877258-61cc-dd2d-fac7-4f2a5c6293e7@appl-ecosys.com> <9d899286-3a73-4894-a6e0-eab529c92e65@gmx.net> <3216489-758a-faef-b21b-84c9679f53c@appl-ecosys.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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.klaver@aklaver.com