Excel MS Query multiple select statements

Hi all,
I have a problem with MS Query in Excel.
I have multiple select statements which MS Query can't interpret.
I'm doing a query to Informix database, and if I have only one select
statement, everything works ok, but if I try to retreive the data from 2 or
3 databases I have to use several select statements, and MS Query can't do
that.
I'm getting an error "Didn't expect ";" after the column list in the ORDER
BY clause"
SQL statement on the database server works fine.

Can anyone help me with this ?

Thanks !
--
Pozdrav
Revenger
11.5.2006 15:14:23
Jednom su proizveli Chuck Norris toalet papir, ali papir nije dopustao da
itko sere po njemu.

If all queries return the same number of columns, join then with UNION ALL

SELECT a,b,c from d
UNION ALL
SELECT a,b,c from e
UNION ALL
SELECT a,b,c from f

HTH
--
AP

"Revenger" <[email protected]> a écrit dans le message de news:
[email protected]...
> Hi all,
> I have a problem with MS Query in Excel.
> I have multiple select statements which MS Query can't interpret.
> I'm doing a query to Informix database, and if I have only one select
> statement, everything works ok, but if I try to retreive the data from 2
> or
> 3 databases I have to use several select statements, and MS Query can't do
> that.
> I'm getting an error "Didn't expect ";" after the column list in the ORDER
> BY clause"
> SQL statement on the database server works fine.
>
> Can anyone help me with this ?
>
> Thanks !
> --
> Pozdrav
> Revenger
> 11.5.2006 15:14:23
> Jednom su proizveli Chuck Norris toalet papir, ali papir nije dopustao da
> itko sere po njemu.

On Thu, 11 May 2006 15:54:42 +0200, Ardus Petus wrote:

> If all queries return the same number of columns, join then with UNION ALL
>
> SELECT a,b,c from d
> UNION ALL
> SELECT a,b,c from e
> UNION ALL
> SELECT a,b,c from f

Thanks ! This helps alot !


--
Pozdrav
Revenger
12.5.2006 12:23:18
Jednom su proizveli Chuck Norris toalet papir, ali papir nije dopustao da
itko sere po njemu.

Your last post was quite empy!!!

--
AP

"Revenger" <[email protected]> a écrit dans le message de news:
[email protected]...
> On Thu, 11 May 2006 15:54:42 +0200, Ardus Petus wrote:
>
>> If all queries return the same number of columns, join then with UNION
>> ALL
>>
>> SELECT a,b,c from d
>> UNION ALL
>> SELECT a,b,c from e
>> UNION ALL
>> SELECT a,b,c from f
>
> Thanks ! This helps alot !
>
>
> --
> Pozdrav
> Revenger
> 12.5.2006 12:23:18
> Jednom su proizveli Chuck Norris toalet papir, ali papir nije dopustao da
> itko sere po njemu.