At 01:43 PM 1/03/2005 -0800, you wrote:

>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?

Yes. The DSQL tab is for executable queries - DDL and queries that return
singleton results (like SELECT COUNT(*), etc.).

Use the Cursor tab for SELECT queries.

./heLen