Inner join Within an Outer join

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Inner join Within an Outer join

Author

Topic

baze7
Yak Posting Veteran

58 Posts

Posted - 2010-06-21 : 17:26:42

Can I use inner join from within an outer join? lets say I wanted to inner join a table po with a link of po.item in the following?

left outer join(
select item from item) as i2 where i2.item = i.item

Thanks

lazerath
Constraint Violating Yak Guru

343 Posts

Posted - 2010-06-21 : 17:50:17

Example Syntax:

SELECT     *
FROM       dbo.TEST1
AS         t1
LEFT JOIN  (
           dbo.TEST2
AS         t2
JOIN       dbo.TEST3
AS         t3
ON         t2.TEST2PK
=          t3.TEST2PK
           )
ON         t1.TEST1PK
=          t2.TEST1PK

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources