One Star

tMySQLInput : Complex Query Multiple DB ?

Hi guys!
Can I do with one tMySQLInput a complex query including this to a multiple databases in the same server? Please can you orient me about this?
Thanks in advance, best regards.
1 REPLY
Community Manager

Re: tMySQLInput : Complex Query Multiple DB ?

Hello
Yes, you need specify the database name before table name. For example:
"SELECT * FROM databaseA WHERE id IN (SELECT databaseB.emp.id FROM databaseB.emp)"
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business