Subqueries in Sybase

[Palmero]

Hi all,

The following SQL syntax does work on Oracle, but not on Sybase.
Do you have a workaround without using a temporary table?
Thanks in advance for your help.

SELECT T1.code,T2.label FROM
(SELECT ......) T1,
(SELECT ......) T2
WHERE T1.code=T2.code;

Palmero.

 

[swampBoogie]

Technically, that is not a subquery but rather a derived table.