Restricting outer join

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » Restricting outer join

Restricting outer join

Rate Topic

Display Mode

Topic Options

Author

Message

Andrew Smith-2007

Posted Sunday, August 10, 2008 7:12 AM

Valued Member

Group: General Forum Members
Last Login: Friday, July 20, 2012 2:22 PM
Points: 53, Visits: 53

All,

I couldn't find any posts on this, feel free to point me in the direction if there are rather than retyping an answer.

I've joined tables A and B with an outer join

select ....
from A left outer join B on a.field1=b.field2

Now I want to inner join B on C to restrict using a value in C. How do I do this?

If I do

select ....
from A left outer join B on a.field1 on b.field2
inner join C on b.field3=c.field4

then I think I will lose the affects of the outer join?

I this is the best way of explaining this...

Thanks

Andrew

Post #549853

SwePeso

Posted Sunday, August 10, 2008 7:47 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:26 PM
Points: 2,359, Visits: 3,292

You can use a derived table.

SELECT		.... 
from		A
left join	(
			SELECT		*
			FROM		B
			inner join	C on c.field4 = b.field3
		) AS x on x.field2 on a.field1

N 56°04'39.16"
E 12°55'05.25"

Post #549857

Andrew Smith-2007

Posted Sunday, August 10, 2008 8:16 AM

Valued Member

Group: General Forum Members
Last Login: Friday, July 20, 2012 2:22 PM
Points: 53, Visits: 53

Peso,

Thank you.

Andrew

Post #549859

« Prev Topic | Next Topic »

Permissions