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 -> Re: SQL question

Re: SQL question

From: Ole Christian Meldahl <konocm_at_statoil.com>
Date: Fri, 15 Oct 1999 09:24:00 +0200
Message-ID: <3806D690.E7F2EF9@statoil.com>


Luis Campos wrote:

> What da heck do you mean by 'mising' (missing) records?
>

Who knows? One way to go is to create a cartesian product and exclude already exisiting?

Select t1.smm, t2.datum
from t1 t1,

           t1 t2
minus
select smm, datum
from t1

ole c Received on Fri Oct 15 1999 - 02:24:00 CDT

Original text of this message

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