java.sql.SQLSyntaxErrorException: Unknown table 'h' in field list

[Anonymous]

Im trying to export data from a MySQL database to an Excel file. However, when I use the DBInput component and enter in my query I receive the following error message. 

My query has multiple joins to other tables and I used "h" as an alias for one of the tables. If I run the same query in MySql Workbench it works.

[manodwhb]

@JeremyKing2 , is the same query executing successfully when you run outside of Talend? 

[ThWabi]

Hello JeremyKing2,

have you tried removing the commented line "-- select *"?

Talend Studio might recognize it and display it in green, but after building the Java code, the SQL statement string sent to the database might not be the full text of your query.

Best regards,

Thomas