Hi guys...
I got very strange problem where the query can execute with /, -, and * maths operators but it cannot execute query that has + (addition) operator.
Example;
SELECT id_cost_type AS a,
1000*200 AS b, 2000 AS c
FROM table
(or 1000-200, 1000/200) is OK but,
SELECT id_cost_type AS a,
1000+200 AS b, 2000 AS c
FROM table
will come out with error!
Please can anyone help me with this? I spent hours try to solve this. This is very important and urgent :-(
Thank you.