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 1s8Jya-00BkhS-P5 for pgsql-general@arkaria.postgresql.org; Sat, 18 May 2024 13:19:54 +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 1s8Jya-005tsA-I4 for pgsql-general@arkaria.postgresql.org; Sat, 18 May 2024 13:19:52 +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 1s8Jya-005ts1-4Q for pgsql-general@lists.postgresql.org; Sat, 18 May 2024 13:19:52 +0000 Received: from mout.gmx.net ([212.227.17.22]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s8JyS-000sXf-BL for pgsql-general@lists.postgresql.org; Sat, 18 May 2024 13:19:51 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1716038383; x=1716643183; i=shammat@gmx.net; bh=GdoNNZ24RHOMdrpnog1e89jdgF2qBbAX2cCI3MO18jE=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To: References:From:In-Reply-To:Content-Type: Content-Transfer-Encoding:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=KcK/2DrN/bOULOyXVr9Vr14mdfp5ri5hsfqy7LCv3QN6YK3fuksOll/50Gveppeq fsa7i6OSigp4WBYlQbXgJt9MlUeeUAokBjkTKWmMr+CzFaaeOys7SJqNGddLjY8mM O8DALcS+gZCL5P13V+8vO36Eb1NJRKQG+YtQBaWoImVuILWDMGKgS/1yAO/yOLb9c o9AG6JwxfPfMDTK4zQkdaWYfGPesUg+1byE+IsqXQbRJRCfhFFaMe0Rp7MHxJUQdy lT860bj2by8cYvWKR+IH7Bws+Ze1M51q1W24D20t/0ylvl02VsawJfzUka2IsCWEI 3PfRmMdKaaIEpcMTIQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [192.168.178.31] ([88.217.180.65]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MdebB-1shen81AxN-00ZdXv for ; Sat, 18 May 2024 15:19:43 +0200 Message-ID: <9d899286-3a73-4894-a6e0-eab529c92e65@gmx.net> Date: Sat, 18 May 2024 15:19:41 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Left join syntax error To: pgsql-general@lists.postgresql.org References: <2c877258-61cc-dd2d-fac7-4f2a5c6293e7@appl-ecosys.com> Content-Language: en-MW From: Shammat In-Reply-To: <2c877258-61cc-dd2d-fac7-4f2a5c6293e7@appl-ecosys.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:AUMVUjXY2fVrRYsY71dRzjLjAcy5rxlLRlxBK0m854POwWSgiNJ z6kJJpiYFM/usQyCuX6kZYl1gPD0LbfrQuaUZEwCzm9OqZplHObBSfO2RYBpFvkB3q9Oueg AkoFlMfbY+PWSeiKsUHWc0eEHura7NFuj3IdRylBW+rOCq872Nmsb9nnjaNpl5Lhw1pGvUO VB7IQfilRsZxW4uNgfiuQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:MgOmBLn6gpw=;LhHbolcTh5eUvXlW0jjmTAsZIkd jBUktLSY3m9jtrxXQ8a9G5GwPF4Ju25kxYQo6hcY4Qebv9sDzBgD6UiGoczRcIG6D2ahF3Szy pclUkNteNFY99Wzy46J+7DnuM0jAqdWDz4AA3fPwVH2qFz+qkai9353RusOOQHMxb0JMJHmtD jwCWcgpYGwg1qFfXVqV4HuMJ1S42RdMApcsPVj0+EJzBdU/Rsmdc21lWYEI9OSykhpAkDZTJ6 BFDpi85ODC9JuEUV/GmA7Xrg9TJZEx96RbYmBzcy1YnOGyM2OVO/xLjEYQJKc2poUlmZMR+hw Vd6RV63Q1thhux/DFc4tAn7jftOft2M1YBOSxpxVy05s/JVotD7qfm6VOCk/Ve1bFlF38Q28D AxBbN7revNlSXSbZVScp/9RzWb3yNElE0iW0tf44w7U3WzysAIdUzaCkKbUDEspL9bqKhhMpE 2rCefdzSmMe+w+y4/n9sFrejL/DRLWl1cvYxSbUIMRLzguSk8aOC4aRwYPOyIPN3BbOtowa9L 68biYEjYmK+AERVrDf7W6MkeVdUJwDEdEMHKRRx9qiRIeh68fzWlAEZj/+NeOniov5gkIOG1O q9c54jBa25JRkARUPFtA/N22OsTktohwZ1G7yofeUY+B5lA9ZpBBf2NMEoY5OQ4g6xZqKwR7x zeeVg4e+zjtrxs1Zbx7NDeDGQb881jd9MYuXuJuYtitgLK1+biOUjLqCYdx6a4d85w+SFaB+I jllZ042KHGtTzjqK275+FxFpOS43jc9NP48XZph1UAujZHnguI+RzB8XryR7SYnQm4NF9fzSQ TGTGWbEnbfYtAr0NsxEQ3eUZZ6Wn50DT8sJGUfptUgQwI= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am 18.05.24 um 14:52 schrieb Rich Shepard: > It's been a _very_ long time since I wrote a SQL script and, despite loo= king > at my SQL books and web pages, I don't know how to fix the error. > > The three line script is: > ----- > SELECT p.lname, p.fname, p.job_title, p.company_nbr, p.email, c.company_= name > =C2=A0 FROM people as p, companies as c > LEFT JOIN companies ON c.company_nbr =3D p.company_nbr; > ----- > > and psql responds: > ERROR:=C2=A0 invalid reference to FROM-clause entry for table "p" > LINE 3: LEFT JOIN companies ON c.company_nbr =3D p.company_nbr; > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ^ > HINT:=C2=A0 There is an entry for table "p", but it cannot be referenced= from this part of the query. Don't put the second table in the FROM part SELECT p.lname, p.fname, p.job_title, p.company_nbr, p.email, c.company_na= me FROM people as p LEFT JOIN companies as c ON c.company_nbr =3D p.company_nbr