Unknown column 'cbal.status' in 'field list'

[Anonymous]

MysqlInput_1:
"select u.id, cbal.status as gateway_status, ...
I start the job:
Exception in component tMysqlInput_1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'cbal.status' in 'field list'

[Anonymous]

We cannot help you if you do not post the whole select statement. Obviously a table with the alias cbal has no column status or the alias is wrong. In the first place this problem is not caused by Talend Studio, it is your query which does not work.

[Anonymous]

hi,
the error tell you the reason :

cbal.status is unknown column

check spelling of that column (some uppercase ?)
regards
laurent