Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.
Labels (2)
1 Reply
Anonymous
Not applicable
Author

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