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

--000000000000b5e2cc064d89f43d
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thank you David for the quick response. I placed the new column two columns
before and it works. I just can't understand why it does not when added to
the end. But anyway it works where it is now.
Thank you again.

Ibrahim Shaame

On Sat, Mar 21, 2026 at 5:42=E2=80=AFPM David G. Johnston <
david.g.johnston@gmail.com> wrote:

> On Saturday, March 21, 2026, Ibrahim Shaame <ishaame@gmail.com> wrote:
>
>>
>> FROM michango2 a, majina2 b
>>
>> WHERE a.mlipaji =3D 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 joi=
n
> syntax and move the join condition to the ON clause, getting rid of the
> where clause with the apparent issue.
>
> David J.
>
>

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

<div dir=3D"ltr"><div>Thank you David for the quick response. I placed the =
new column two columns before and it works. I just can&#39;t understand why=
 it does not when added to the end. But anyway it works where it is now.</d=
iv><div>Thank you again.</div><div><br></div><div>Ibrahim Shaame=C2=A0</div=
></div><br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr=
" class=3D"gmail_attr">On Sat, Mar 21, 2026 at 5:42=E2=80=AFPM David G. Joh=
nston &lt;<a href=3D"mailto:david.g.johnston@gmail.com">david.g.johnston@gm=
ail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"=
margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-lef=
t:1ex">On Saturday, March 21, 2026, Ibrahim Shaame &lt;<a href=3D"mailto:is=
haame@gmail.com" target=3D"_blank">ishaame@gmail.com</a>&gt; wrote:<br><blo=
ckquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left=
:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div><br></d=
iv><div><p style=3D"margin-bottom:0.1in;line-height:115%;background:transpa=
rent">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>
</blockquote></div>

--000000000000b5e2cc064d89f43d--