Microsoft SQL Server 2012 - 11.0.5058.0 (X64)

Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

I heard something about default predicates by same column name, but in my case same columns names exists in multiple table which take part in this query, also you can see that gs predicated is on next line, so from a side it looks like "sub JOIN". I just want to break the code...

This piece came also from very reputable person, and after his tuning the whole piece running faster...

I'll try to compose test code with AdventrureWorks and see how it works.

Thanks

M