var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Where with a select
I use ASE 22.214.171.124
I need to do a select with a another select in condition.
Like this :
select * from TabA where name=(select name from TabB)
I need to get the select all the name of TabB, not just one.
When I launch it, I've got :
"a subquery returned several values. This is illegal when the subquery is preceded by =, !=, <, <= , >, >=, or used as an expression.
If someone has an idea.
You can change the "=" to "in"
But will probably get better performance with a "where exists"
select * from TabA where exists
(select 1 from TabB where TabB.name=TabA.name)