Re: SQL query

Article View: be.comp.programming

Article #1056

Back to be.comp.programming Previous Next

#1056

From: bd
Date: Mon, 26 Dec 2005 18:06

37 lines
1809 bytes

Euhm,

SELECT tblFilmGenre.genre
FROM tblFilmGenre
WHERE tblFilmGenre.GenreId NOT IN (SELECT tblHeeftFilm.GenreId FROM
tblHeeftFilm)

?
Bedoel je dit ?

Groetjes,

Bert



"Bart Vandewoestyne" <MyFirstName.MyLastName@telenet.be> schreef in bericht
news:1135610739.15413@seven.kulnet.kuleuven.ac.be...
> Ieps,
>
> Mijn broer zou volgende query willen doen in Microsoft Access,
> maar 't lukt hem precies niet en mijn praktische SQL kennis is nu
> ook niet supergroot...
>
> Twee tabellen:
>
> tblFilmGenre met kolommen GenreId en Genre
> tblHeeftFilm met kolommen FilmId en GenreId
>
> Hij wil nu alle genres krijgen die geen films toegewezen hebben.
> Hoe doen we dat ook alweer?
>
> Greetzzz,
> Bart
>
> --
> "Share what you know.  Learn what you don't."

Technical Details

Message-ID: <XiWrf.81414$zD6.5102705@phobos.telenet-ops.be>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!feed4.newsreader.com!newsreader.com!feed7.newsreader.com!nntp.telenet.be!kwabbernoot.telenet-ops.be!phobos.telenet-ops.be.POSTED!not-for-mail

References: <1135610739.15413@seven.kulnet.kuleuven.ac.be>

Show Full Headers

Complete Article Headers

X-Google-Thread: fcea4,a795e842cf93de5e
X-Google-Attributes: gidfcea4,public
X-Google-Language: DUTCH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!feed4.newsreader.com!newsreader.com!feed7.newsreader.com!nntp.telenet.be!kwabbernoot.telenet-ops.be!phobos.telenet-ops.be.POSTED!not-for-mail
From: "bd" <bertdemuynck@pandora.be>
Newsgroups: be.comp.programming
References: <1135610739.15413@seven.kulnet.kuleuven.ac.be>
Subject: Re: SQL query
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <XiWrf.81414$zD6.5102705@phobos.telenet-ops.be>
Date: Mon, 26 Dec 2005 18:06:47 GMT
NNTP-Posting-Host: 213.224.109.156
X-Complaints-To: abuse@telenet.be
X-Trace: phobos.telenet-ops.be 1135620407 213.224.109.156 (Mon, 26 Dec 2005 19:06:47 MET)
NNTP-Posting-Date: Mon, 26 Dec 2005 19:06:47 MET
Organization: Telenet Internet

Reply to Parent Message