Subject | Multiple Rows in Singleton Select?!?! I don't get it. |
---|---|
Author | Joe Martinez |
Post date | 2005-03-01T21:43:50Z |
I typed the following query into the DSQL tab of IB_SQL:
select customerid from enrolls A where A.sectionid in (select B.sectionid
from sections B where sectionstartdate >= '1/1/03' and sectionstartdate <=
'1/1/04') and enrollwaiting <> 'T'
I get an error back, saying "multiple rows in singleton select". I don't
understand. I don't see a singleton select anywhere in that query.
Anyone understand why I'm getting this error?
-Joe
select customerid from enrolls A where A.sectionid in (select B.sectionid
from sections B where sectionstartdate >= '1/1/03' and sectionstartdate <=
'1/1/04') and enrollwaiting <> 'T'
I get an error back, saying "multiple rows in singleton select". I don't
understand. I don't see a singleton select anywhere in that query.
Anyone understand why I'm getting this error?
-Joe