Re: Merging two queries and I get syntax errors

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(dot)g(dot)johnston(at)gmail(dot)com> wrote:

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