can left join be nested within left join?

[tamilselvan]

Yes, you can have more than 1 left outer join in SQL Server.

Example:
select *
from tablea left outer join tableb on tablea.col = tableb.col
left outer join tablec on tablea.col = tablec.col