Re: Hj�lp til SQL

Article View: dk.edb.database

Article #15118

#15118

From: JH
Date: Tue, 10 Jul 2001 15:20

9 lines
1344 bytes

> �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)

Technical Details

Message-ID: <a07mkts39qka9g4nrd1laqkp12tsi730vq@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.97.206.81!kinglear.mobilixnet.dk!news.tele.dk!not-for-mail

References:

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

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:19:31 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.97.206.81!kinglear.mobilixnet.dk!news.tele.dk!not-for-mail
From: JH <newsfilter2@dk2net.dk>
Newsgroups: dk.edb.database
Subject: Re: Hj�lp til SQL
Date: Tue, 10 Jul 2001 17:20:16 +0200
Message-ID: <a07mkts39qka9g4nrd1laqkp12tsi730vq@4ax.com>
References: <3b4adf9e$0$3243$ba624c82@nntp01.dk.telia.net> <pnplktcff70bnegdioufgp1li3miapdfp3@4ax.com> <3b4b14f4$0$31243$ba624c82@nntp01.dk.telia.net>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
Lines: 11
Organization: TDC Internet
NNTP-Posting-Host: 62.242.172.177
X-Trace: 994778370 dread04.news.tele.dk 941 62.242.172.177
X-Complaints-To: abuse@post.tele.dk

Reply to Parent Message