Joining results of two queries

From: Victor <victor_at_vanhillo.net>
Date: 17 Apr 2003 13:56:51 -0700
Message-ID: <d4b0e293.0304171256.2e82ffcf_at_posting.google.com>

Hello there,

I have a query problem and i hope you can help me out:

I haven two result of a query:

Query1 result                     Query2 Result
-------------                     -------------
A;B;C;D                           A;B;C;D;Q;R;S
A;B;C;D                           A;B;C;D;Q;R;S
etc....                           etc...

I want to join them together that the result looks (for example) like this:

A;B;C;D
A;B;C;D;Q;R;S
A;B;C;D;Q;R;S
A;B;C;D;
A;B;C;D;Q;R;S
A;B;C;D;Q;R;S
A;B;C;D;Q;R;S
A;B;C;D;Q;R;S

Is this possible? Thanks in advance! Received on Thu Apr 17 2003 - 22:56:51 CEST

This message: [ Message body ]
Next message: Sateesh Kumar: "Re: Help in UTL_FILE"
Previous message: uthra: "URGENT - RTF IN REPORTS 6.0"
Next in thread: Alex Filonov: "Re: Joining results of two queries"
Reply: lve: "Re: Joining results of two queries"
Reply: Alex Filonov: "Re: Joining results of two queries"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message