Discussion board where members can get started with QlikView.
In MySQL, I have two different databases -- let's call them A and B.
Database A resides on server server1, while database B resides on server server2.
Is it possible to perform a SQL JOIN between a table that is in database A, to a table that is in database B?
Go to Solution.
Try this script
ODBC CONNECT TO [MySQL Servidor];
transactions_backup.ad_id AS AdID,
transactions_backup.campaign_id AS CampaignID
where transactions_backup.event_type_id in (3, 13, 18)
and transactions_backup.ad_id = offers.ad_id
ODBC CONNECT TO MySQL *******;
JOIN (Tab1) SELECT
offers.ad_id AS AdID
campaigns.id as CampaignID,
WHERE campaigns.campaign_type = 4;
Hope this helps you.
first establish the connectivity from Server1 and read the table A.
then establish the connectivity from server 2 and read the table B.
and apply the join.
table A from server1
connectivity from server2:
table 2 from server 2;
How can I make the following join "and transactions_backup.ad_id = offers.ad_id" in Tab2 and "and transactions_backup.campaign_id = campaigns.id" in Tab3? The fields names are different in case 2.
and transactions.campaign_id = campaigns.id