on 11-17-2015 5:57 PM
Hello,
I am able to run the 1st pass through SQL
select count(*) as cnt1,
(select count(*) as cnt2 from table1 where var1 is null)
from table1
However, the 2nd SQL failed with "undefined index" error message.
select count(*) as cnt1,
(select count(*) as cnt2 from table1 where var1 is null),
(select count(*) as cnt3 from table1 where var1<0)
from table1
Does anybody know why?
Thanks.
There's no such thing as an "undefined index" in SQL Anywhere.
What product is producing this message?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Which version did you use?
I tested this SQL statement in the following environment.
SQL Anywhere 17.0.0.1010 on Windows 8.1
I confirmed the success of both SQL statements(1st, 2nd).
Thanks,
Atsushi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.