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: Selecting from joined tables (simple question)

Re: Selecting from joined tables (simple question)

From: willy_gates <willy_gates_at_hotmail.com>
Date: Thu, 29 Jan 2004 11:51:14 +0000 (UTC)
Message-ID: <bvas3h$nvn$1@sparta.btinternet.com> 





> something like this?

>

> select ds.id from DATA_STANDARD ds, DATA_EXTRA de

> where

> ( ds.id not in ( select DS_ID from DATA_EXTRA ) )

> or

> (

>   --Join

>   ( ds.id = de.DS_ID )

>   and

>   ( de.extra_value is null )

> )

>

> Why is this wrong?




I still don't know but I suppose I should be using an OUTER JOIN



>

> Thanks

Received on Thu Jan 29 2004 - 05:51:14 CST












Original text of this message













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