topic Re: Transfom performance from inner join of inner join in MS SQL in QlikView

Transfom performance from inner join of inner join in MS SQL

qvhjenvo — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I have following sql-scripts like this

select distinct

m.garnr as garnr,

m1.garnr as m1_garnr

from m_table m

inner join a_table a on m.key1_m_table = a.key1_m_table

inner join a_table a1 on a1.key2_a_table = a.key2_a_table

inner join m_table m1 on m1.key1_m_table = a1.key1_m_table

How to express performance in transform in QV?

Thanks in advance

Loi

Re: Transfom performance from inner join of inner join in MS SQL

Anil_Babu_Samineni — Wed, 28 Sep 2016 09:11:43 GMT

What is your intend usually

Re: Transfom performance from inner join of inner join in MS SQL

qvhjenvo — Wed, 28 Sep 2016 10:01:10 GMT

My intend is to find m1.garnr that are belong to m.garnr. They are in the same m_table that has a key (key1_m_table ). But they have a connection in the a_table (key1_m_table , key2_a_table).