Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qvhjenvo
Contributor
Contributor

Transfom performance from inner join of inner join in MS SQL

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

2 Replies
Anil_Babu_Samineni

What is your intend usually

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
qvhjenvo
Contributor
Contributor
Author

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).