Re: [GENERAL] left join a parenthesised inner join group

2005-11-03 Thread Sim Zacks
My bad. It is doing what it is supposed to. Now I just have to figure out why it is not giving me the results I am looking for. Sim "Sim Zacks" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I tried the following code and was very suprised this didn't work the way I > had expected

[GENERAL] left join a parenthesised inner join group

2005-11-03 Thread Sim Zacks
I tried the following code and was very suprised this didn't work the way I had expected it to. Is my expectation correct or the way that it implements it correct? select * from a left join ( b join c on b.f1=c.f1 join d on d.f2=c.f2 join e on e.f3=d.f3) on a.f4=b.f4 I would like it to have all t