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. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly