Xref: alice comp.databases.oracle.tools:21055
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.cwix.com!144.212.100.101!newsfeed.mathworks.com!nntprelay.mathworks.com!gatech!news01.aud.alcatel.com!usenet
From: Austin Moseley <austinmoseley@hotmail.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: null values in oracle
Date: Tue, 02 Feb 1999 14:42:26 -0600
Organization: Self
Lines: 19
Message-ID: <36B76332.18A72BE0@hotmail.com>
References: <7973og$5jh@news3.euro.net> <36B73869.972E33C0@co.boulder.co.us>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.05 [en] (WinNT; U)

Yes, just add "AND variable_name IS NOT NULL"
to your where clause. Or, alternatively, make the column
a NOT NULL column.

-A

>
>
> > Is there anyway to avoid that records with null values in a
> > join are not taken ???
> >
> > Thanks in advance
> >
> > Filip Vantomme
> >
> > Please also mail any replies.