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