Re: sql vraagje

Article View: be.comp.programming

Article #17352

Back to be.comp.programming Previous Next

#17352

From: MindTrap
Date: Wed, 05 Jan 2000 00:00

31 lines
2138 bytes

> 2. werk met tabel-aliasen.
>    (zoiets als:
>     SELECT TABLE1.ID
>     FROM TABLE AS TABLE1, TABLE AS TABLE2
>     WHERE  (TABLE1.ID = TABLE2.ID)
>       AND  (TABLE1.type = 1 AND TABLE1.waarde = "eerste")
>       AND  (TABLE2.type = 2 AND TABLE2.waarde = "tweede")
>    )
> 3. werk met een geneste subquery (ineffici�nt).
>     SELECT ID
>     FROM TABLE
>     WHERE (type = 1 AND waarde = "eerste") AND
>           ID IN
>              SELECT ID FROM TABLE
>              WHERE type = 2 AND waarde = "tweede"
> 
> Nota's:
> 1. Het zou kunnen dat hier een paar syntax-fouten instaan.
> 2. Ik denk niet dat MySQL die twee vormen laatste ondersteund.

euhm.. hier geraak ik ni echt wijs uit... bedoelt ge dat mysql die 2
laatsten niet ondersteunt? (zodat ik dus toch geen [zij het trage]
oplossing heb)

> --
> ben . de . rydt at pandora . be ------------------ your comments
> http://users.pandora.be/bdr/ ------- inl. IPv6, Linux en Pandora

-- 
---
A clear conscience is usually the sign of a bad memory.

Technical Details

Message-ID: <3873B456.6CF9D6C9@linuxfreak.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References:

<3873800B.CE8DB5BE@linuxfreak.com> <387382DE.95EA1484@co.and.co> <3873898A.B94BA56E@linuxfreak.com> <38738B1A.FCD7C056@co.and.co> <38738B31.57FF9425@linuxfreak.com> <38738CD3.8878F89C@co.and.co> <387393B9.FC892506@linuxfreak.com> <38739698.5B8A5570@co.and.co> <3873A908.8D2AB38A@linuxfreak.com> <3873AEE7.3F8BAD3A@co.and.co>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII
X-Google-Thread: fcea4,adf63b3fcd32c9b4
X-Google-Attributes: gidfcea4,public
From: MindTrap <IDONTLIKESPAM.MindTrap@linuxfreak.com>
Subject: Re: sql vraagje
Date: 2000/01/05
Message-ID: <3873B456.6CF9D6C9@linuxfreak.com>
X-Deja-AN: 568803075
Cache-Post-Path: marvin!unknown@tvd-10-67-52-33.tvd.kotnet.kuleuven.ac.be
Content-Transfer-Encoding: 8bit
References: <3873800B.CE8DB5BE@linuxfreak.com> <387382DE.95EA1484@co.and.co> <3873898A.B94BA56E@linuxfreak.com> <38738B1A.FCD7C056@co.and.co> <38738B31.57FF9425@linuxfreak.com> <38738CD3.8878F89C@co.and.co> <387393B9.FC892506@linuxfreak.com> <38739698.5B8A5570@co.and.co> <3873A908.8D2AB38A@linuxfreak.com> <3873AEE7.3F8BAD3A@co.and.co>
X-Accept-Language: en
Content-Type: text/plain; charset=iso-8859-1
X-Complaints-To: abuse@belnet.be
X-Trace: naxos.belnet.be 947106903 4962 134.58.127.3 (5 Jan 2000 21:15:03 GMT)
Organization: KULeuvenNet
X-Cache: nntpcache 2.3.3 (see http://www.nntpcache.org/)
Mime-Version: 1.0
NNTP-Posting-Date: 5 Jan 2000 21:15:03 GMT
Newsgroups: be.comp.programming

Reply to Parent Message