|
|
Posted by Larry Linson on 06/15/06 03:26
If I understand the question, my vote goes to Piet's solution. If you have
unmatched rows in either Query, then you'd need something a bit different.
Larry Linson
Microsoft Access MVP
"vivekian" <vivekaseeja@gmail.com> wrote in message
news:1150320359.977336.291500@i40g2000cwc.googlegroups.com...
> 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
>
> If a union is done for both the queries , we get the results in rows.
> How can the above be done.
>
> Thanks in advance,
> vivekian
>
Navigation:
[Reply to this message]
|