Re: Results in Parallel columns

From: <pietlinden_at_hotmail.com>
Date: 14 Jun 2006 15:03:25 -0700
Message-ID: <1150322605.380447.175340_at_y41g2000cwy.googlegroups.com>


vivekian wrote:
> Hi ,
>
> I need to place the results of two different queries in the same result
> table parallel to each other.
> So if the result of the first query is
>
> 1 12
> 2 34
> 3 45
>
> and the second query is
>
> 1 34
> 2 44
> 3 98
>
> the results should be displayed as
>
> 1 12 34
> 2 34 44
> 3 45 98
>
SELECT qry1.fld1 As FirstField, qry1.fld2 As SecondField, qry2.fild2 as ThirdField
FROM qry1 INNER JOIN qry2 ON qry1.Field1=qry2.fld1 ORDER BY FirstField Received on Thu Jun 15 2006 - 00:03:25 CEST

Original text of this message