Java Error : "table" cannot be resolved to a type

[Anonymous]

Dear experts, 

I have issue with my tPostgresqlRow. I would like to execute this query : 

UPDATE fait_vehicule_staging SET accident_id = fait_lieu_staging.accident_id

from fait_lieu_staging

where fait_vehicule_staging.lieu_id =  fait_lieu_staging.lieu_id

It works fine in a standard PGAmin for ex but not in Talend. I have this error which i don't understand : 

fait_usager_staging cannot be resolved to a type

Thank you for all your answers. Best regards.

[ashif2 · Accepted solution]

Please try the update statement with double quotes like below: 

"
UPDATE b SET data = a.data
from a
where a.id = b.id
"

[Anonymous]

Hello, 

Thank you for your answer. 

I've tried it and I have no more this error.