var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sub-query in FROM clause
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.
Originally Posted by alirulez999
you don't need to use a subquery in the FROM clause for this query
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