sub-query in FROM clause

alirulez999 · #1 (**permalink**) 02-18-10, 02:19

hi,

select sub.*
from
(
select a
from
table1

union all

select a
from
table2
)sub

this query gives error in sybase 12.0. Whereas when the same query was executed in sybase 15 version, it works fine. This says that 12.0 does not support sub-query in FROM clause.

Any other alternative to achieve this in sybase 12.0

Got stuck, please help.

r937 · #2 (**permalink**) 02-18-10, 04:14

Quote:

Originally Posted by alirulez999

Any other alternative to achieve this in sybase 12.0

Code:

SELECT a
  FROM table1
UNION ALL
SELECT a
  FROM table2

you don't need to use a subquery in the FROM clause for this query

pdreyer · #3 (**permalink**) 02-18-10, 06:45

A derived table is similar to a view
So in pre 12.5 versions;
Create a view of the union and then select from the view

Internet Services

Web Development

Digital Marketing

Consumer Tech