Article View: be.comp.programming
Article #6028Re: [SQL] Tabellen combineren
From: YuGo
Date: Thu, 23 Jan 2003 14:05
Date: Thu, 23 Jan 2003 14:05
14 lines
1363 bytes
1363 bytes
> > SELECT * FROM tabel1 > UNION > SELECT * FROM tabel2 > > ofwel, als je niet wil dat dubbele rijen eruit gefilterd worden: > > SELECT * FROM tabel1 > UNION ALL > SELECT * FROM tabel2 > Dat is de oplossing, thx
Technical Details
Message-ID:
<_ESX9.1779$Jd.93@afrodite.telenet-ops.be>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!news.mailgate.org!newsfeeder.edisontel.com!skynet.be!skynet.be!ossa.telenet-ops.be!afrodite.telenet-ops.be.POSTED!not-for-mailReferences:
<blSX9.1754$Jd.348@afrodite.telenet-ops.be> <1tSX9.1767$Jd.461@afrodite.telenet-ops.be>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcea4,af576473eea19a4b X-Google-Attributes: gidfcea4,public X-Google-ArrivalTime: 2003-01-23 06:05:49 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!news.mailgate.org!newsfeeder.edisontel.com!skynet.be!skynet.be!ossa.telenet-ops.be!afrodite.telenet-ops.be.POSTED!not-for-mail From: "_YuGo_" <yugo(geenspam)@pandora.be> Newsgroups: be.comp.programming References: <blSX9.1754$Jd.348@afrodite.telenet-ops.be> <1tSX9.1767$Jd.461@afrodite.telenet-ops.be> Subject: Re: [SQL] Tabellen combineren Lines: 16 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: <_ESX9.1779$Jd.93@afrodite.telenet-ops.be> Date: Thu, 23 Jan 2003 14:05:46 GMT NNTP-Posting-Host: 213.119.19.60 X-Complaints-To: abuse@telenet.be X-Trace: afrodite.telenet-ops.be 1043330746 213.119.19.60 (Thu, 23 Jan 2003 15:05:46 MET) NNTP-Posting-Date: Thu, 23 Jan 2003 15:05:46 MET Organization: Telenet Internet