Re: Selecting from joined tables (simple question)

From: Manish <manishrb_at_hotmail.com>
Date: 29 Jan 2004 08:53:44 -0800
Message-ID: <55e6afeb.0401290853.76000a7d@posting.google.com>

Try

--Join --

ds.id = de.DS_ID(+) and de.extra_value is null

willy_gates_at_hotmail.com (willy gates) wrote in message news:<4344f587.0401290317.3de963b3_at_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 - 10:53:44 CST