The following SQL runs on SQLServer:

select col1, sum( col2 ) from (
select col1, col2 from table1
union all
select col1, col2 from table2
) as sub
group by col1

but I can't get Sybase to recognise this as SQL.

How can accomplish the same thing in Sybase ?

Thanks
Andy

This syntax, with 'derived tables' (aka. 'inline views') is supported by ASE
12.5.1 (which was released in October 2003). Earlier versions of ASE don't
support this syntax.

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of "The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/qr

mailto:rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

"Andy K" <magiciandor@yahoo.com> wrote in message
news:e402c831.0311140709.6e2d712a@posting.google.c om...
> The following SQL runs on SQLServer:
>
> select col1, sum( col2 ) from (
> select col1, col2 from table1
> union all
> select col1, col2 from table2
> ) as sub
> group by col1
>
> but I can't get Sybase to recognise this as SQL.
>
> How can accomplish the same thing in Sybase ?
>
> Thanks
> Andy

In article <e402c831.0311140709.6e2d712a@posting.google.com >, Andy K wrote:
> The following SQL runs on SQLServer:
>
> select col1, sum( col2 ) from (
> select col1, col2 from table1
> union all
> select col1, col2 from table2
> ) as sub
> group by col1
>
> but I can't get Sybase to recognise this as SQL.
>
> How can accomplish the same thing in Sybase ?
>

See Rob's answer, but this may be your work-around:

select col1, col2 into #table
from table1
insert into #table
select col1, col2 from table2
select col1, sum( col2 ) from #table
group by col1
go
drop table #table
go



--
___ _
| _ \___ _ _ ___//
| / -_) ' \/ -_)
|_|_\___|_||_\___|