From: | Sim Zacks <sim(at)compulab(dot)co(dot)il> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: left join a parenthesised inner join group |
Date: | 2005-11-03 12:20:14 |
Message-ID: | 829901349.20051103142014@compulab.co.il |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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" <sim(at)compulab(dot)co(dot)il> wrote in message news:dkcsji$qbl$1(at)news(dot)hub(dot)org(dot)(dot)(dot)
> 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 the rows from a left joined with the total inner
> join of the rest.
> It actually performs it as if I did not have parenthesis at all and had the
> inner join connected to the left outer join thereby excluding all rows that
> do not have a match from b to c
>
> Thank You
> Sim
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | David Gagnon | 2005-11-03 12:36:19 | Re: Problem with array in plpgsql function .. please help |
Previous Message | Yonatan Ben-Nes | 2005-11-03 12:19:54 | Re: SQL injection |