Re: Merging two queries and I get syntax errors

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.