Re: Select with dual-field empty

Sonnich wrote:
> Hi
>
> I havent touched oracle for some time...
>
> I want to do a select from 2 tables, where the connection between the
> tables are fields, but the row migth not exist
>
> e.g.
>
> select * from a, b where a.code=b.code(+), but like this:
>
> select * from a, b
> where a.code1=b.code1(+)
> and a.code2=b.code2(+)
>
> the point is that both code1 and 2 has to be there.
>
> Any idea how I can do this?
>
> BR
> Sonnich

WHERE a.code1 IS NOT NULL
AND a.code2 IS NOT NULL

But given that NULL <> NULL I'm not sure you actually have an issue.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org