Re: How to Merge Results of two Identical TADOQuery ?

Article View: borland.public.cppbuilder.database.ado

Article #3334

Back to borland.public.cppbuilder.database.ado Previous Next

#3334

From: Giuliano
Date: Sun, 22 Sep 2002 13:05

31 lines
1678 bytes

On Sun, 22 Sep 2002 13:41:14 +0100, "Helcio Mayor"
<HelcioLiza@mayorgroves.fsnet.co.uk> wrote:

>Dear all, and thaks for allowing me to have this opportunity to put my
>question.
>I have two queries object whereby the SQL query is identical, except for the
>Datetime
>parameter. Is it possible to locally add the rows of one query to the other
>as if I had
>performed a sigle query ?
>Thanks,
>

Hi, 

    why you don't use a UNION?

<resulting_query> :=
    <query1>
      UNION
    <query2>

for example:

select a,b,c from tbl where c between :date1 AND :date2
UNION
select a,b,c from tbl where c between :date3 AND :date4

Ciao!

Giuliano

Technical Details

Message-ID: <drfrou4v37uim499fj7kahlah7fq5d2oel@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!news2.euro.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3d8dba5d@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,987d87b864cc93d4
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-09-22 06:12:02 PST
From: Giuliano <gcardinali@remove.adhoc.net>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: How to Merge Results of two Identical TADOQuery ?
Date: Sun, 22 Sep 2002 15:05:30 +0200
Message-ID: <drfrou4v37uim499fj7kahlah7fq5d2oel@4ax.com>
References: <3d8dba5d@newsgroups.borland.com>
X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 81.72.236.130
X-Trace: newsgroups.borland.com 1032699926 81.72.236.130 (22 Sep 2002 06:05:26 -0700)
Lines: 31
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!news2.euro.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message