Re: mysql + klucze + dobieranie

Article View: pl.comp.bazy-danych

Article #183338

Back to pl.comp.bazy-danych Previous Next

#183338

From: kabot
Date: Wed, 08 Jul 2009 14:27

32 lines
2295 bytes

On 8 Lip, 12:04, Kraskovich <kraskov...@gmail.com> wrote:
> artykuly:
> 15 | tytul 1 | jakas tam tresc
> 16 | tylul 2 | jakas tam tresc 2
>
> klucze:
> docieplanie | 15
> systemy | 15
> docieplanie | 16
> inny klucz | 16
>
> kazdy artykul moze miec wiele kluczy
>
> potrzebuje wyciagnac id_artykulu ktory posiada tylko
> klucze='docieplanie' wylaczajac nazwa_klucza='systemy'
>
> np. nazwa_klucza='docieplanie' and nazwa_klucza!='systemy'
>
> id=15 nie ma sie wyswietlac a interesowac bedzie mnie id=16
>
> ------------------------
> zalezy mi tez na pozniejszym dobieraniu i wykluczaniu konkretnych
> 'nazwa_klucza'

Spróbuj w taki sposób:
select * from artykul a
where exsits (select 1 from klucze where nazwa_klucza='jakis klucz'
and id_artykulu=a.id)
and not exists (select 1 from klucze where nazwa_klucza='inny klucz'
and id_artykulu=a.id)

pzdr

Technical Details

Message-ID: <b389e809-a8a6-49ed-a889-375c60198723@t21g2000yqi.googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.onet.pl!news.nask.pl!news.nask.org.pl!news.uni-stuttgart.de!news.stw-bonn.de!news.netcologne.de!newsfeed-fusi2.netcologne.de!newsfeed.straub-nv.de!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!198.186.194.250.MISMATCH!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!t21g2000yqi.googlegroups.com!not-for-mail

References: <h31qv8$j8l$1@inews.gazeta.pl>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.onet.pl!news.nask.pl!news.nask.org.pl!news.uni-stuttgart.de!news.stw-bonn.de!news.netcologne.de!newsfeed-fusi2.netcologne.de!newsfeed.straub-nv.de!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!198.186.194.250.MISMATCH!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!t21g2000yqi.googlegroups.com!not-for-mail
From: kabot <kabotnet@gmail.com>
Newsgroups: pl.comp.bazy-danych
Subject: Re: mysql + klucze + dobieranie
Date: Wed, 8 Jul 2009 07:27:51 -0700 (PDT)
Organization: http://groups.google.com
Lines: 32
Message-ID: <b389e809-a8a6-49ed-a889-375c60198723@t21g2000yqi.googlegroups.com>
References: <h31qv8$j8l$1@inews.gazeta.pl>
NNTP-Posting-Host: 83.16.209.218
Mime-Version: 1.0
X-Trace: posting.google.com 1247063272 25803 127.0.0.1 (8 Jul 2009 14:27:52 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 8 Jul 2009 14:27:52 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: t21g2000yqi.googlegroups.com; posting-host=83.16.209.218;  posting-account=a8M6-goAAACuHke02WwbEX461w3rbxFE
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10)  Gecko/2009042316 Firefox/3.0.10,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 firewall.comp-win.pl:3128 (squid/2.6.STABLE6)
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message