Joining MySQL tables from different sources

[#1]

I'm having issues joining tables from different databases. One table only exists on one database. When I attempt to join them through Qlikview I am getting null values in different rows. Here is a visual:

Unique_Key	Yes/No	Employee_1	Employee_2	Text_1	Text_2	Text_3	On/Off	Count
123456	Yes	-	Michael Jackson	Text	Text	Text	-	-
	-	James Brown	-	-	-	-	On	1
1234567	-	James Brown	-	-	-	-	Off	1
	No	-	Michael Jackson	Text	Text	Text	-	-

The dashes represent null values. Is there a way to join SQL tables in Qlik where the end result is 1 row of values for each Unique_Key?

[Anonymous]

It looks like a result of concatenate rather than join.  Can you share the script or upload the app?

[#3]

Unfortunately no I can't upload the app.

Basically, "Employee_1" is the only info I need from the table cross databases. So Table_1 is grabbing the data, and Table_2 is also grabbing the data, resulting in multiple rows. As you can see though, the data exists in only 1 column, not both.

I was wondering if there was some sort of Qlik function where I could combine rows.

[Anonymous]

But you can show the portions of the script, can't you?  So far is not clear how exactly you're tying to join.

If you have Table1 with a Key and Field_A and Table2 with Key and Field_B, it should be

Table:

LOAD Key, Field_A;

SQL SELECT Key, Field_A FROM Table1;

JOIN (Table) LOAD Key, Field_B;

SQL SELECT Key, Field_B FROM Table2;