var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ASE Problem Subquery
I use ASE 220.127.116.11 and I want to do a subquery.
I found the syntax.
select city from (select city from publishers)
select city from (select city from publishers) cities
When I launch it I've got the following message :
[Error Code: 156, SQL State: ZZZZZ] Incorrect syntax near keyword 'select'
Did anyone knows the right syntax
select * from tablename where city in ( select city from publishers) .
I want to do a subquery with two tables.
select heure from
(select heure1 as heure from tab1
select heure2 as heure from tab2)
but this syntax doesn't work.
Why you are not use only this syntax mentioned below?
select heure1 as heure from tab1
select heure2 as heure from tab2
Because I want the max hour of the two columns
Derived tables is only available with ASE 12.5.1 and later
As a work around create a view on your query
then select from the view