| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Ibrahim Shaame <ishaame(at)gmail(dot)com> |
| Cc: | "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Merging two queries and I get syntax errors |
| Date: | 2026-03-21 14:42:56 |
| Message-ID: | CAKFQuwZR6wOYTjVGKpk=ZjUJ=VkdT7ZfYHbe1Di4daPMy16hGw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Saturday, March 21, 2026, Ibrahim Shaame <ishaame(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ibrahim Shaame | 2026-03-21 14:52:35 | Re: Merging two queries and I get syntax errors |
| Previous Message | Ibrahim Shaame | 2026-03-21 14:31:42 | Merging two queries and I get syntax errors |