Re: SQL vraagje

Article View: be.comp.programming

Article #13690

Back to be.comp.programming Previous Next

#13690

From: KLinZ
Date: Sat, 09 Jun 2001 10:00

17 lines
1645 bytes

"Rene Pijlman" <reageer.in.de.nieuwsgroep@onzin-adres.nl> wrote in message
news:nfs3itop5f7de62uq3g7tc0d2eh95gib8g@4ax.com...
> "KLinZ" <klinz@hetnet.nl> schreef:
> >> Ik wil nu enkel alle gegevens uit de records 23 maart 1998, 23 maart
1999,
> >> 23 maart 2000 en 23 maart 2001.
> >SELECT * FROM tableX WHERE date = '1998-03-23' AND date = '1999-03-23'
>
> Als iemand zegt "ik wil alle koeien en paarden" dan zeg je in SQL
> "geef me alle dieren die koe zijn OF paard zijn", niet "de dieren die
> koe EN paard zijn", want dat zijn er niet veel :-)
>

Jaja :) Klopt helemaal!

Joris

Technical Details

Message-ID: <9fss6i$5no2p$1@ID-79907.news.dfncis.de>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!newscore.gigabell.net!fu-berlin.de!uni-berlin.de!c71152.upc-c.chello.NL!not-for-mail

References: <9fsr7v$svp$1@mykenos.hogent.be> <9fsre0$5mh3a$1@ID-79907.news.dfncis.de> <nfs3itop5f7de62uq3g7tc0d2eh95gib8g@4ax.com>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: 107324,64d771637e141bf4
X-Google-Attributes: gid107324,public
X-Google-Thread: fcea4,64d771637e141bf4
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2001-06-09 03:01:56 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!newscore.gigabell.net!fu-berlin.de!uni-berlin.de!c71152.upc-c.chello.NL!not-for-mail
From: "KLinZ" <klinz@hetnet.nl>
Newsgroups: be.comp.programming,nl.comp.programmeren
Subject: Re: SQL vraagje
Date: Sat, 9 Jun 2001 12:00:09 +0200
Lines: 19
Message-ID: <9fss6i$5no2p$1@ID-79907.news.dfncis.de>
References: <9fsr7v$svp$1@mykenos.hogent.be> <9fsre0$5mh3a$1@ID-79907.news.dfncis.de> <nfs3itop5f7de62uq3g7tc0d2eh95gib8g@4ax.com>
NNTP-Posting-Host: c71152.upc-c.chello.nl (212.187.71.152)
X-Trace: fu-berlin.de 992080914 6021209 212.187.71.152 (16 [79907])
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200

Reply to Parent Message