MIME-Version: 1.0
In-Reply-To: 
 <CAJOWwD7r5e_s=X1ZJEc0jVYdcGiMnkGik0m=Q=1t8hmBTT0vFQ@mail.gmail.com>
References: 
 <CAJOWwD7r5e_s=X1ZJEc0jVYdcGiMnkGik0m=Q=1t8hmBTT0vFQ@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sat, 21 Mar 2026 07:42:56 -0700
Message-ID: 
 <CAKFQuwZR6wOYTjVGKpk=ZjUJ=VkdT7ZfYHbe1Di4daPMy16hGw@mail.gmail.com>
Subject: Re: Merging two queries and I get syntax errors
To: Ibrahim Shaame <ishaame@gmail.com>
Cc: "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000004a25bf064d89d146"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwZR6wOYTjVGKpk%3DZjUJ%3DVkdT7ZfYHbe1Di4daPMy16hGw%40mail.gmail.com>
Precedence: bulk

--0000000000004a25bf064d89d146
Content-Type: text/plain; charset="UTF-8"

On Saturday, March 21, 2026, Ibrahim Shaame <ishaame@gmail.com> wrote:

>
> FROM michango2 a, majina2 b
>
> WHERE a.mlipaji = b.namba
>
>
> Here it does not work and I get the message:
>
> ERROR:  syntax error at or near "a"
> LINE 1: ...1 AS miezi_deni FROM michango2 a, majina2 b WHERE a.mlipaji
>
> and it point at a.mlipaji
>

Nothing seems obviously wrong which leads me to suspect some nonprinting
character issues.  Try writing/rebuilding the query in small increments
until you get the error again then manually retype the last added chunk.
Or just take the opportunity to use a more conventional explicit ANSI join
syntax and move the join condition to the ON clause, getting rid of the
where clause with the apparent issue.

David J.

--0000000000004a25bf064d89d146
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Saturday, March 21, 2026, Ibrahim Shaame &lt;<a href=3D"mailto:ishaame@g=
mail.com">ishaame@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex=
"><div dir=3D"ltr"><div><br></div><div><p style=3D"margin-bottom:0.1in;line=
-height:115%;background:transparent">FROM michango2
a,=C2=A0majina2 b=C2=A0</p><p style=3D"margin-bottom:0.1in;line-height:115%=
;background:transparent">WHERE a.mlipaji =3D b.namba=C2=A0</p><p style=3D"m=
argin-bottom:0.1in;line-height:115%;background:transparent"><br></p><p styl=
e=3D"margin-bottom:0.1in;line-height:115%;background:transparent">Here it d=
oes not work and I get the message:</p><p style=3D"margin-bottom:0.1in;line=
-height:115%;background:transparent">ERROR: =C2=A0syntax error at or near &=
quot;a&quot;<br>LINE 1: ...1 AS miezi_deni FROM michango2 a,=C2=A0majina2 b=
=C2=A0WHERE a.mlipaji</p><p style=3D"margin-bottom:0.1in;line-height:115%;b=
ackground:transparent">and it point at a.mlipaji</p></div></div></blockquot=
e><div><br></div><div>Nothing seems obviously wrong which leads me to suspe=
ct some nonprinting character issues.=C2=A0 Try writing/rebuilding the quer=
y in small increments until you get the error again then manually retype th=
e last added chunk.=C2=A0 Or just take the opportunity to use a more conven=
tional explicit ANSI join syntax and move the join condition to the ON clau=
se, getting rid of the where clause with the apparent issue.</div><div><br>=
</div><div>David J.</div><div><br></div>

--0000000000004a25bf064d89d146--