Re: SQL question

From: <buurd_at_my-deja.com>
Date: Thu, 14 Oct 1999 12:32:23 GMT
Message-ID: <7u4igm$gce$1@nnrp1.deja.com>

if you can manufakture (or allready has) a complete table you could do a left/right join and look for elements with null vaules.

regards

In article <7u4cjm$t58$1_at_SOLAIR2.EUnet.yu>, "Rexx" <nebacar_nospam_at_eunet.yu> wrote:
> HI,
>
> can I do in SQL next query
>
> I have table (eg.) T1 with two columns SMM and DATUM
>
> SMM DATUM
> --------- -----------
> 1000 1-10-1997
> 1000 1-10-1998
> 1000 1-10-1999
>
> 2000 1-10-1997
> 2000 1-10-1998
>
> 3000 1-10-1997
> 3000 1-10-1998
> 3000 1-10-1999
>
> 4000 1-10-1997
> 4000 1-10-1998
>
> I need to get "mising " records
>
> 2000 1-10-1999
> 4000 1-10-1999
> --
>
> Remove nospam from address
> nebacar_at_eunet.yu
>
>

--
Roland Carlsson
Certified Java programmer
Skövde
Sweden

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 14 1999 - 07:32:23 CDT