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?
Printable View
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?
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
would access97 support such a thing? b/c that's what i'm using.