Hi,

Can not we use a subselect as a tablo in informix ?

For example, i get an error in this statement

select vxmlsessionvariable.sessionid,max(eventdatetime)
from vxmlsessionvariable, vxmlsession where vxmlsession.sessionid = vxmlsessionvariable.sessionid and varname= "AgentTransferInfo"
group by vxmlsessionvariable.sessionid ) AS X
Where a.sessionid=X.sessionid

Thanks.

Well, your query has unbalanced brackets so it _IS_ syntax error.
HTH