August 10, 2008 at 7:12 am
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
August 10, 2008 at 7:47 am
You can use a derived table.SELECT....
fromA
left join(
SELECT*
FROMB
inner joinC on c.field4 = b.field3
) AS x on x.field2 on a.field1
N 56°04'39.16"
E 12°55'05.25"
August 10, 2008 at 8:16 am
Peso,
Thank you.
Andrew
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply