Hi Team,

I do have 4 tables lets say A, B, C and D and my sample SQL statement looks like as shown in SQL#1 below.

I was trying to mimic the same in Power BI using Advanced Editior-->Merging. But I see the different result and the SQL it generates looks like as shown in SQL#2 below.

SQL#1:

SELECT * FROM A

LEFT JOIN B ON A.C1=B.C1

LEFT JOIN C ON A.C2=B.C2

LEFT JOIN D ON A.C3=D.C3

SQL#2:

SELECT * FROM

     (SELECT * FROM

               (SELECT * FROM A

                 LEFT JOIN B ON A.C1=B.C1

                ) AA

        LEFT JOIN C ON AA.C2=B.C2

    ) BB

LEFT JOIN D ON BB.C3=D.C3