Hi I'm migrating an SP from Sybase to SQL Server and in some query I have a multiple left outer join (*= operator) table1.a *= table2.a table1.c *= table3.c table1.d *= table4.c table2.e *= table5.e table2.f *= table6.f table5.g *= table7.g table6.h *= table8.h Which I'm trying to modify to SQL conventional LEFT JOIN, however I'm unable to make it work given that the same table is used in several places of the joins... table1 left join with table2 table1 left join with table3 table1 left join with table4 table2 left join with table5 table2 left join with table6 table5 left join with table7 table6 left join with table8 Any ideas??