Re: Joining results of two queries
Date: 18 Apr 2003 10:16:21 -0700
Message-ID: <93096888.0304180916.1f3b8b56_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!
Do a Join of two tables without where clause. It is called cross join.
lv Received on Fri Apr 18 2003 - 19:16:21 CEST