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

Home -> Community -> Usenet -> c.d.o.server -> Re: External join

Re: External join

From: Dmitry Andreyev <dmitry0000_at_yahoo.com>
Date: Wed, 28 Nov 2001 09:40:01 +0200
Message-ID: <3c049463@news.bezeqint.net> 






"Sylvain BOURDETTE" <sbourdette_at_danet.fr> wrote in message
news:3bf1239c$0$15829$626a54ce_at_news.free.fr...


> What is the syntax for an external join on Oracle 8i ?

>




SELECT A.*, B.*



FROM TABLEA A, TABLEB B



WHERE A.ID=(+)B.ID

Received on Wed Nov 28 2001 - 01:40:01 CST












Original text of this message













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