Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Merging Records

Re: Merging Records

From: Keith Boulton <boulkenospam_at_globalnet.co.uk>
Date: 1998/05/25
Message-ID: <35694939.4828459@read.news.global.net.uk>#1/1

On Wed, 20 May 1998 17:25:16 +0100, Allan Speir <r31055_at_email.sps.mot.com> wrote:

>This is a multi-part message in MIME format.
>--------------27C3D16BA16A29CD066A501D
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>Hello,
>
>I'm currently trying to merge the results of several queries with the
>same record structure but containing different values.
>
>e.g.
>
>If I had 3 records as follows
>
>1 2 3 a b d f
>1 2 3 a b c d f
>4 5 6 7 8 9 x y z
>
>I would like the result to be
>1 2 3 a b c d f
>4 5 6 7 8 9 x y z
>
>I tried the SQL set operator UNION but this seems only to work with
>records which are identical.
>

Union should work so long as the datatypes match i.e. put to_char around number columns in one query if they are character columns in the other. Received on Mon May 25 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US