https://community.qlik.com/t5/Talend-Studio/tMySQLInput-Complex-Query-Multiple-DB/m-p/2326591#M96063 Hello <BR />Yes, you need specify the database name before table name. For example: <BR />"SELECT * FROM databaseA WHERE id IN (SELECT databaseB.emp.id FROM databaseB.emp)" <BR />Best regards <BR />Shong Tue, 23 Mar 2010 06:37:54 GMT Anonymous 2010-03-23T06:37:54Z https://community.qlik.com/t5/Talend-Studio/tMySQLInput-Complex-Query-Multiple-DB/m-p/2326590#M96062 Hi guys!<BR />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?<BR />Thanks in advance, best regards. Sat, 16 Nov 2024 13:29:39 GMT https://community.qlik.com/t5/Talend-Studio/tMySQLInput-Complex-Query-Multiple-DB/m-p/2326590#M96062 Anonymous 2024-11-16T13:29:39Z https://community.qlik.com/t5/Talend-Studio/tMySQLInput-Complex-Query-Multiple-DB/m-p/2326591#M96063 Hello <BR />Yes, you need specify the database name before table name. For example: <BR />"SELECT * FROM databaseA WHERE id IN (SELECT databaseB.emp.id FROM databaseB.emp)" <BR />Best regards <BR />Shong Tue, 23 Mar 2010 06:37:54 GMT https://community.qlik.com/t5/Talend-Studio/tMySQLInput-Complex-Query-Multiple-DB/m-p/2326591#M96063 Anonymous 2010-03-23T06:37:54Z