-
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?
thanks!
arage
-
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.
thanks!
arage
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|