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 -> Re: LEFT JOIN ORACLE, is difirent LEFT JOIN POSTGRES?

Re: LEFT JOIN ORACLE, is difirent LEFT JOIN POSTGRES?

From: <askot_at_ut.ee>
Date: Sat, 28 Jun 2003 20:56:54 +0000 (UTC)
Message-ID: <bdkvem$kst$1@kadri.ut.ee> 





> In postgres-->




> SELECT *


> FROM esc_usuarios uu LEFT JOIN esc_temas t ON (uu.id_tema=t.id_tema)) S1

> WHERE esc_usuarios.id_usuario=1

>      AND esc_usuarios.baja='N'




Oracle knows ANSI outer joins too.




Asko...
Received on Sat Jun 28 2003 - 15:56:54 CDT












Original text of this message













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