Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Sintaxis del OUTER JOIN

Sintaxis del OUTER JOIN

From: David M.G. <gespol_at_redestb.es>
Date: 1997/11/24
Message-ID: <01bcf8c4$39c7b8c0$44cf7ac3@w95>#1/1

Hola,

        Me llamo Marc y estoy buscando desesperadamente la sintaxis del operador (+) para una OUTER JOIN multiple. Me explico un poco mejor ?

        Graficamente En SQL (de Oracle) En pseudo-SQL Comentario

	A --- 0		select *			select *			Outer join

| from A,B from A, outer B simple de
B where A.x=B.x (+) where A.x = B.x una tabla. A --- 0 select * select * Outer join
| from A,B,C from A, outer (B,C) multiple.
B ---- C ??????? where A.x = B.x A --- 0 select * select * Y esto??
| from A,B from A, outer (B, outer C)
B ---- 0 ??????? where A.x = B.x | C Muchas, muchisimas gracias. Atentamente: Marc Bria Ramirez
Received on Mon Nov 24 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US