Re: sql problem

Article View: be.comp.programming

Article #12886

Back to be.comp.programming Previous Next

#12886

From: Roel Schroeven
Date: Thu, 13 Sep 2001 19:00

43 lines
2349 bytes

In article <aR_n7.51875$6x5.10975870@afrodite.telenet-ops.be>, "dnl_70"
<christof.denolf@pandora.be> wrote:

> kan ieman mij verder helpen met volgend probleem ik heb ��n tabel
> met volgende kolommen Country en Mountain ik wil de countries selecteren
> die dezelfde bergen delen
> 
> vb :
> Country    Mountain
> Frankrijk             mb
> Zwitserland          mb
> Italie                    mb
> Frankrijk             tp
> Oostenrijk            mh
> Zwitserland           mh
> 
> met onderstaande sql :
> select ct1.country, ct2.country, ct1.mountain from country ct1, country
> ct2
> where ct1.mountain = ct2.mountain and ct1.country <> ct2.country

select ct1.country, ct2.country, ct1.mountian from country ct1, country
ct2 where ct1.mountain = ct2.mountina and ct1.country < ct2.country

m.a.w. < i.p.v. <>

> 
> met deze sql kom ik nog stteds een aantal rijen die overbodig zijn mn
> 
> Italie            Frankrijk     mb
> Frankrijk     Italie            mb
> ....
> 
> hoe kan ik ook deze rijen elemineren
> 
> dank


-- 
Roel Schroeven
x3jmyi0yrrn3h001@sneakemail.com (anti-spam email address from sneakemail.com)

"Don't blame me if there are bugs. Blame the cute, furry one." - Rusty Russell

Technical Details

Message-ID: <pan.2001.09.13.21.00.31.706.2614@sneakemail.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!diablo.theplanet.net!colt.net!newsfeeds.belnet.be!news.belnet.be!ossa.telenet-ops.be!afrodite.telenet-ops.be.POSTED!not-for-mail

References: <aR_n7.51875$6x5.10975870@afrodite.telenet-ops.be>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII
X-Google-Thread: fcea4,879ac781ac2e2f60
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2001-09-13 12:00:36 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!diablo.theplanet.net!colt.net!newsfeeds.belnet.be!news.belnet.be!ossa.telenet-ops.be!afrodite.telenet-ops.be.POSTED!not-for-mail
From: "Roel Schroeven" <x3jmyi0yrrn3h001@sneakemail.com>
Subject: Re: sql problem
Newsgroups: be.comp.programming
Message-ID: <pan.2001.09.13.21.00.31.706.2614@sneakemail.com>
References: <aR_n7.51875$6x5.10975870@afrodite.telenet-ops.be>
User-Agent: Pan/0.10.0 (Unix)
Mime-Version: 1.0
Content-Type: text/plain; charset=ANSI_X3.4-1968
Content-Transfer-Encoding: 8bit
X-Comment-To: "dnl_70" <christof.denolf@pandora.be>
Lines: 43
Date: Thu, 13 Sep 2001 19:00:34 GMT
NNTP-Posting-Host: 213.224.72.140
X-Complaints-To: abuse@pandora.be
X-Trace: afrodite.telenet-ops.be 1000407634 213.224.72.140 (Thu, 13 Sep 2001 21:00:34 MET DST)
NNTP-Posting-Date: Thu, 13 Sep 2001 21:00:34 MET DST
Organization: Telenet Internet

Reply to Parent Message