Discussion Board for collaboration on QlikView Scripting.
I have a mysql table containing the names of several databases, and I want to make the same query in that databases.
So I would need something like that:
select db from mydatabases;
for( every db in mydatabases )
select name from db.employees;
Can anyone give me an idea of how to manage with this?
Thanks in advance.
Use database names from Excel sheet in a For Loop for Connection String.
can help you
May be like this,
Connect to Server1.MyDatabase
SQL select tableA.*
From Server1.MyDatabase.tableA as tableA
SQL select tableB.*
From Server2.MyDatabase.tableB as tableB
You can call as resident table .By Making Joins You required to all Tables.