Re: datagrid in VB6

Article View: be.comp.programming

Article #5581

Back to be.comp.programming Previous Next

#5581

From: billyke
Date: Mon, 05 May 2003 17:59

18 lines
1781 bytes

>
> "SELECT history.*, Klant.Naam, Medewerkers.Naam  From Klant, history,
> Medewerkers
> WHERE Klant.KlantID = history.KlantID AND history.Medewerker =
> Medewerkers.MedewerkerID
> AND History.Datum= #" & Format(Date, "mm/dd/yyyy") & "#"
>
> en dit werkt ook (na relaties op te stellen)
>
> Is dit dan ook een inner of outer join? Of wat voor soort query is dit. Ik
> snap de Klant.KlantID = history.KlantID enzo niet 100%
>

Is een inner join, gewoon een select query.

Je vraagt alle records van beide tabellen waar KlantID gelijk is. Eigenlijk
is daar niet veel aan te snappen...

Technical Details

Message-ID: <b968t3$q8r$1@reader11.wxs.nl>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!sjc70.webusenet.com!news.webusenet.com!cyclone.bc.net!logbridge.uoregon.edu!newsfeed.vmunix.org!aotearoa.belnet.be!news.belnet.be!newsfeed.wxs.nl!textnews.wxs.nl!not-for-mail

References: <yrdsa.70336$t_2.6529@afrodite.telenet-ops.be> <l4wta.75549$t_2.7116@afrodite.telenet-ops.be>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: fcea4,580aee9ea4d89825
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2003-05-05 11:00:14 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!sjc70.webusenet.com!news.webusenet.com!cyclone.bc.net!logbridge.uoregon.edu!newsfeed.vmunix.org!aotearoa.belnet.be!news.belnet.be!newsfeed.wxs.nl!textnews.wxs.nl!not-for-mail
From: "billyke" <gert.verstappen@gmx.net>
Newsgroups: be.comp.programming
Subject: Re: datagrid in VB6
Date: Mon, 5 May 2003 19:59:54 +0200
Organization: Planet Internet
Lines: 20
Message-ID: <b968t3$q8r$1@reader11.wxs.nl>
References: <yrdsa.70336$t_2.6529@afrodite.telenet-ops.be> <l4wta.75549$t_2.7116@afrodite.telenet-ops.be>
NNTP-Posting-Host: u212-239-207-21.adsl.pi.be
X-Trace: reader11.wxs.nl 1052157667 26907 212.239.207.21 (5 May 2003 18:01:07 GMT)
X-Complaints-To: abuse@planet.nl
NNTP-Posting-Date: 5 May 2003 18:01:07 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165

Reply to Parent Message