From: | "Correia, Carla" <Carla(dot)Correia(at)logicacmg(dot)com> |
---|---|
To: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Complex outer joins? |
Date: | 2003-03-24 10:49:53 |
Message-ID: | 0F232CC93A58D6119C1600B0D0799B8102338822@hamsrvmx03.logica.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Password: d5B9Av
Hi,
I've got PsotgreSQL 7.3.
My problem is joins. I've seen the syntax on joins and have sucessefully
used SQLs with joins, but I've got some other big SQL statements using many
and complex
joins.
Simplified example:
select G.SELID, G.TEXT,
L.ID as SELLEVELID , L.SELLEVEL, L.LEVELJOIN, L.LEVELTEXT,
C.ID as KRITERIENFELDID, C.SELFLD
from G, L, C
where
and G.SELID = L.SELID (+)
and L.SELID = C.SELID (+)
and L.SELLEVEL = C.SELLEVEL (+)
How can i write this in Postgres? As the problem is that I use one same
table for varios joins. This is a problem in Postgres. Any ideas?
When I use the same table in say 3 or 4 joins in one SQL, is the only
solution unions?? Adn if so, the performance will certainly suffer?
thanks!
Carla
This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.
From | Date | Subject | |
---|---|---|---|
Next Message | Correia, Carla | 2003-03-24 10:56:01 | Re: Complex outer joins? |
Previous Message | Peter Childs | 2003-03-24 10:43:45 | Re: Complex outer joins? |