can left join be nested within left join?

[arage]

I have a left join between a table & a query but require the query to have another left join from another table. Is it therefore possible to nest a left join within another 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

[arage]

would access97 support such a thing? b/c that's what i'm using.