Transfom performance from inner join of inner join in MS SQL

[qvhjenvo]

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

[Anil_Babu_Samineni]

What is your intend usually

[qvhjenvo]

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