Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL - UNION statement

Re: SQL - UNION statement

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 9 Dec 1998 06:44:00 GMT
Message-ID: <74l67g$g1$1@news01.btx.dtag.de>


Jan Nowitzky schrieb:
>
> Matthias Gresz wrote:
>
> > suisum_at_ecn.ab.ca schrieb:
> > >
> > > Hi all:
> > >
> > > Anyone know what the purpose of the following SQL statement? Why we need
> > > UNION?
> > > ...
>
> Hi Matthias,
>
> the difference is

it's not the only one.

>
> (1) e.disb_no = '000' and
> (2) e.disb_no != '000'.
> The reason could be NULL-Values!
>
> (1) supplies all disb_no which match the string '000'
> (2) supplies all disb_no which doesent match these string. Especially it means,
> that tupels with disb_no = NULL will not be selected!
>
> Regards,
> Jan

Regards
Matthias
--
Matthias.Gresz_at_Privat.Post.DE

Always log on the bright side of life.
http://www.stone-dead.asn.au/movies/life-of-brian/brian-31.htm Received on Wed Dec 09 1998 - 00:44:00 CST

Original text of this message

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