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.
