Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Sintaxis del OUTER JOIN
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 joinReceived on Mon Nov 24 1997 - 00:00:00 CST
| 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
![]() |
![]() |