public inbox for pgsql-novice@postgresql.org  

help / color / mirror / Atom feed

From: Ibrahim Shaame <ishaame@gmail.com>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-novice@lists.postgresql.org <pgsql-novice@lists.postgresql.org>
Subject: Re: Merging two queries and I get syntax errors
Date: Sat, 21 Mar 2026 17:52:35 +0300
Message-ID: <CAJOWwD7NvHZTaMUJiJ9=yH4gpyTHkc1n9t6cN7Z0Ox00PbNgrg@mail.gmail.com> (raw)
In-Reply-To: <CAKFQuwZR6wOYTjVGKpk=ZjUJ=VkdT7ZfYHbe1Di4daPMy16hGw@mail.gmail.com>
References: <CAJOWwD7r5e_s=X1ZJEc0jVYdcGiMnkGik0m=Q=1t8hmBTT0vFQ@mail.gmail.com>
	<CAKFQuwZR6wOYTjVGKpk=ZjUJ=VkdT7ZfYHbe1Di4daPMy16hGw@mail.gmail.com>

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 PM 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 = 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.
>
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-novice@postgresql.org
  Cc: ishaame@gmail.com, david.g.johnston@gmail.com, pgsql-novice@lists.postgresql.org
  Subject: Re: Merging two queries and I get syntax errors
  In-Reply-To: <CAJOWwD7NvHZTaMUJiJ9=yH4gpyTHkc1n9t6cN7Z0Ox00PbNgrg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox