Re: Joining results of two queries
Date: 21 Apr 2003 08:04:23 -0700
Message-ID: <336da121.0304210704.7deeb573_at_posting.google.com>
victor_at_vanhillo.net (Victor) wrote in message news:<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!
Looks like you need a UNION ALL, not a JOIN. Received on Mon Apr 21 2003 - 17:04:23 CEST