Hi,

I'm working on a linux box running FB 1.5.2 , I'm using C language.

The SQL is:

char *sql="select a.phone,a.smscontent,a.mo_id
from mo a inner join phones b on (a.phone=b.phone)
where b.corp_id=? ";

When app running, prepare is ok , but at isc_dsql_execute2, it reports:
--> multiple rows in singleton select <--

The sql is so simple , why it reports "multiple rows in singleton
select"?

I want to know if it is caused by wrong XSQLDA ?