Combining two DataSources

[#1]

Hi, I'm new to QlikView and i have the following question:

I have two connections, to 2 different databases

For example

CONNECT TO DB1

AA: Select A,B,C from table1;

CONNECT TO DB2

BB: Select D,E,F from table2;

I dont know how to use fields from table 1 into a new query combining fields from table2

Somenthing like..:

Select * from AA,BB where AA.A like BB.E;

Thanks for the help

Frank

[#2]

You typically use one field that links tables from both sources (a foreign and primary key?), and give these the exact same fieldname in QV. So if column A from table1 actually refers to column E from table2 you would get:

TABLE1:

CONNECT TO DB1;

SELECT A as key, B, C from table1;

TABLE2:

CONNECT DB2;

SELECT D, E as key, F from table2;

The joining of the tables works automatic when you combine attributes from both tables in one chart.

[#3]

Thanks for your answer

I'm aware of "automatic" join when fields have same name.

But i need something else.

I have two ListBoxs

LIST1     LIST2

A          CAT

B          DOG

C          HAT

So what i need is to filter LIST2 by finding values from LIST1.

For example if I select "A" it should bring CAT and HAT. I need something like a "LIKE" statement, so that's why a simple join isn't enoguht.

Thanks for your help