topic Join multiple tables from database in QlikView

Join multiple tables from database

Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 09 Mar 2016 13:55:04 GMT

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 — Wed, 09 Mar 2016 15:12:58 GMT

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,