Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is your intend usually
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).