Re: Hj�lp til SQL

Article View: dk.edb.database

Article #15119

#15119

From: Cliff Huxtable
Date: Tue, 10 Jul 2001 15:55

17 lines
1643 bytes

"JH" <newsfilter2@dk2net.dk> wrote in message
news:a07mkts39qka9g4nrd1laqkp12tsi730vq@4ax.com...
> > �h.... Ja, det var ogs� mit eget umiddelbare g�t, men det returnerer
alts�
> > et tomt recordset... :(
>
> Jaaa, det kan du sku' have ret i ;) - men s� skal vi nok ud i en mere
> "skummel" version.....
>
> SELECT DISTINCT prodID FROM din_tabel WHERE
>   prodID IN (SELECT prodID FROM din_tabel WHERE typeID = 1) and
>   prodID IN (SELECT prodID FROM din_tabel WHERE typeID = 3)
>

Ja, s'gu' da!
Mange tak. :)

Technical Details

Message-ID: <3b4b25be$0$4661$ba624c82@nntp01.dk.telia.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!wanadoo.fr!opentransit.net!news.tele.dk!212.54.64.131!news100.image.dk!newsfeed101.telia.com!nf01.dk.telia.net!news104.dk.telia.net!not-for-mail

References:

<3b4adf9e$0$3243$ba624c82@nntp01.dk.telia.net> <pnplktcff70bnegdioufgp1li3miapdfp3@4ax.com> <3b4b14f4$0$31243$ba624c82@nntp01.dk.telia.net> <a07mkts39qka9g4nrd1laqkp12tsi730vq@4ax.com>

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,66a3426525c70bc6
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-07-10 08:57:07 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!wanadoo.fr!opentransit.net!news.tele.dk!212.54.64.131!news100.image.dk!newsfeed101.telia.com!nf01.dk.telia.net!news104.dk.telia.net!not-for-mail
From: "Cliff Huxtable" <oldblackguy@thatbigoldhouse.com>
Newsgroups: dk.edb.database
References: <3b4adf9e$0$3243$ba624c82@nntp01.dk.telia.net> <pnplktcff70bnegdioufgp1li3miapdfp3@4ax.com> <3b4b14f4$0$31243$ba624c82@nntp01.dk.telia.net> <a07mkts39qka9g4nrd1laqkp12tsi730vq@4ax.com>
Subject: Re: Hj�lp til SQL
Date: Tue, 10 Jul 2001 17:55:52 +0200
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
Lines: 19
Message-ID: <3b4b25be$0$4661$ba624c82@nntp01.dk.telia.net>
NNTP-Posting-Host: 212.10.1.45
X-Trace: 994780606 news.stofanet.dk 4661 212.10.1.45
X-Complaints-To: Telia Stofa Abuse <abuse@stofa.dk>

Reply to Parent Message