Join multiple tables from database

[#1]

Hi,

Im making an ODBC connection to a database. Where I want to join multiple tables from that database. I know the SQL as followed:

from contnotes n

inner join accounts sub on (n.accno=sub.accno)

inner join accounts main on (sub.mainaccno=main.accno)

inner join instruments i on (n.insid=i.insid)

inner join instrumentclearingmarketplaces icm on (n.insid=icm.insid and icm.isdefaultmarket=1)

inner join marketplaces m on (icm.cmpcode=m.cmpcode)

inner join instrumentnames iname on (n.insid=iname.insid and iname.lngid=29)

So I want to join these set of 6 tables as above. how is that practically made?

Regards

[Gysbert_Wassenaar]

Just use the existing sql statement to retrieve the data and have the database server do all the joining:

MyTable:

SQL SELECT ...etc...;

[santiago_respane]

Hi Niklas,

you can join them directly in SQL and load it as one table in qlikview or you can bring all tables separately and joind them in qlikview.

The second option makes it easier when it comes to new requirements or changes in the model.

Hope this helps.

Kind regards,