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

Selecting from joined tables (simple question)

From: willy gates <willy_gates_at_hotmail.com>
Date: 29 Jan 2004 03:17:45 -0800
Message-ID: <4344f587.0401290317.3de963b3@posting.google.com>


Thanks for help with this one

I have 2 tables

DATA_STANDARD with columns ID and VALUE

and

DATA_EXTRA with column DS_ID and EXTRA_VALUE

The idea is that extra information is stored in the DATA_EXTRA table when required.

How do I select all values from DATA_STANDARD where there is either no entry in DATA_EXTRA or EXTRA_VALUE is zero.

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?

Thanks Received on Thu Jan 29 2004 - 05:17:45 CST

Original text of this message

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