MIME-Version: 1.0
From: Ibrahim Shaame <ishaame@gmail.com>
Date: Sat, 21 Mar 2026 17:31:42 +0300
Message-ID: 
 <CAJOWwD7r5e_s=X1ZJEc0jVYdcGiMnkGik0m=Q=1t8hmBTT0vFQ@mail.gmail.com>
Subject: Merging two queries and I get syntax errors
To: pgsql-novice@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000f017c5064d89a97c"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJOWwD7r5e_s%3DX1ZJEc0jVYdcGiMnkGik0m%3DQ%3D1t8hmBTT0vFQ%40mail.gmail.com>
Precedence: bulk

--000000000000f017c5064d89a97c
Content-Type: text/plain; charset="UTF-8"

I am trying to insert a new column in a working query. When I query I get
the column correctly, but when adding that query to the main column I get
syntax errors Here are the queries:

1 - This one works perfectly:
SELECT (((b.jina::text || ' '::text) || b.baba::text) || ' '::text) ||
b.babu::text AS jina_kamili,
    b.namba,
    a.mlipaji,
    a.kiasi,
    a.imelipwaje,
    to_char(a.kwa_mwezi_wa::timestamp with time zone, 'yyyy'::text) AS
mwaka,
    to_char(a.kwa_mwezi_wa::timestamp with time zone, 'mm'::text) AS mwezi
   FROM michango2 a,
    majina2 b
  WHERE a.mlipaji = b.namba
  ORDER BY ((((b.jina::text || ' '::text) || b.baba::text) || ' '::text) ||
b.babu::text), (to_char(a.kwa_mwezi_wa::timestamp with time zone,
'yyyy'::text)), (to_char(a.kwa_mwezi_wa::timestamp with time zone,
'mm'::text));
******************************************
2 - and this one works perfectly:
SELECT (EXTRACT(YEAR FROM AGE(anza_mchango, CASE WHEN mwisho_mchango ISNULL
THEN NOW() ELSE mwisho_mchango END))*12 + EXTRACT(MONTH FROM
AGE(anza_mchango, CASE WHEN mwisho_mchango ISNULL THEN NOW() ELSE
mwisho_mchango END)))*-1 AS miezi_deni FROM majina2;
**********************************************
3 - But when the second is merged in the first like this:

SELECT (((b.jina::text || ' '::text) || b.baba::text) || ' '::text) ||
b.babu::text AS
jina_kamili, b.namba, a.mlipaji, a.kiasi, a.imelipwaje,
to_char(a.kwa_mwezi_wa::timestamp
with time zone, 'yyyy'::text) AS mwaka, to_char(a.kwa_mwezi_wa::timestamp
with time zone, 'mm'::text) AS mwezi,  (EXTRACT(YEAR FROM AGE(anza_mchango,
CASE WHEN mwisho_mchango ISNULL THEN NOW() ELSE mwisho_mchango END))*12 +
EXTRACT(MONTH FROM AGE(anza_mchango, CASE WHEN mwisho_mchango ISNULL THEN
NOW() ELSE mwisho_mchango END)))*-1 AS miezi_deni

FROM michango2 a, majina2 b

WHERE a.mlipaji = b.namba

ORDER BY ((((b.jina::text || ' '::text) || b.baba::text) || ' '::text) ||
b.babu::text), (to_char(a.kwa_mwezi_wa::timestamp with time zone,
'yyyy'::text)), (to_char(a.kwa_mwezi_wa::timestamp with time zone,
'mm'::text));


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

I would appreciate any hint.

Thanks in advance

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

<div dir=3D"ltr"><div>I am trying to insert a new column in a working query=
. When I query I get the column correctly, but when adding that query to th=
e main column I get syntax errors Here are the queries:</div><div><br></div=
><div>1 - This one works perfectly:</div><div>SELECT (((b.jina::text || =
9; &#39;::text) || b.baba::text) || &#39; &#39;::text) || b.babu::text AS j=
ina_kamili,<br>=C2=A0 =C2=A0 b.namba,<br>=C2=A0 =C2=A0 a.mlipaji,<br>=C2=A0=
 =C2=A0 a.kiasi,<br>=C2=A0 =C2=A0 a.imelipwaje,<br>=C2=A0 =C2=A0 to_char(a.=
kwa_mwezi_wa::timestamp with time zone, &#39;yyyy&#39;::text) AS mwaka,<br>=
=C2=A0 =C2=A0 to_char(a.kwa_mwezi_wa::timestamp with time zone, &#39;mm&#39=
;::text) AS mwezi<br>=C2=A0 =C2=A0FROM michango2 a,<br>=C2=A0 =C2=A0 majina=
2 b<br>=C2=A0 WHERE a.mlipaji =3D b.namba<br>=C2=A0 ORDER BY ((((b.jina::te=
xt || &#39; &#39;::text) || b.baba::text) || &#39; &#39;::text) || b.babu::=
text), (to_char(a.kwa_mwezi_wa::timestamp with time zone, &#39;yyyy&#39;::t=
ext)), (to_char(a.kwa_mwezi_wa::timestamp with time zone, &#39;mm&#39;::tex=
t));</div><div>******************************************</div><div>2 - and=
 this one works perfectly:</div><div>SELECT (EXTRACT(YEAR FROM AGE(anza_mch=
ango, CASE WHEN mwisho_mchango ISNULL THEN NOW() ELSE mwisho_mchango END))*=
12 + EXTRACT(MONTH FROM AGE(anza_mchango, CASE WHEN mwisho_mchango ISNULL T=
HEN NOW() ELSE mwisho_mchango END)))*-1 AS miezi_deni FROM majina2;</div><d=
iv>**********************************************</div><div>3 - But when th=
e second is merged in the first like this:</div><div>


=09
	<span></span>
=09
=09

<p style=3D"margin-bottom:0.1in;line-height:115%;background:transparent">SE=
LECT
(((b.jina::text || &#39; &#39;::text) || b.baba::text) || &#39; &#39;::text=
) ||
b.babu::text AS
jina_kamili,=C2=A0b.namba,=C2=A0a.mlipaji,=C2=A0a.kiasi,=C2=A0a.imelipwaje,=
=C2=A0to_char(a.kwa_mwezi_wa::timestamp
with time zone, &#39;yyyy&#39;::text) AS
mwaka,=C2=A0to_char(a.kwa_mwezi_wa::timestamp with time zone,
&#39;mm&#39;::text) AS mwezi,=C2=A0 (EXTRACT(YEAR FROM AGE(anza_mchango, CA=
SE
WHEN mwisho_mchango ISNULL THEN NOW() ELSE mwisho_mchango END))*12 +
EXTRACT(MONTH FROM AGE(anza_mchango, CASE WHEN mwisho_mchango ISNULL
THEN NOW() ELSE mwisho_mchango END)))*-1 AS miezi_deni=C2=A0</p><p style=3D=
"margin-bottom:0.1in;line-height:115%;background:transparent">FROM michango=
2
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">ORDER BY
((((b.jina::text || &#39; &#39;::text) || b.baba::text) || &#39; &#39;::tex=
t) ||
b.babu::text), (to_char(a.kwa_mwezi_wa::timestamp with time zone,
&#39;yyyy&#39;::text)), (to_char(a.kwa_mwezi_wa::timestamp with time zone,
&#39;mm&#39;::text));</p><p style=3D"margin-bottom:0.1in;line-height:115%;b=
ackground:transparent"><br></p><p style=3D"margin-bottom:0.1in;line-height:=
115%;background:transparent">Here it does 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%;background:transparent">and it point a=
t a.mlipaji</p><p style=3D"margin-bottom:0.1in;line-height:115%;background:=
transparent">I would appreciate any hint.</p><p style=3D"margin-bottom:0.1i=
n;line-height:115%;background:transparent">Thanks in advance</p>

<br></div><div><br></div></div>

--000000000000f017c5064d89a97c--