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.
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