Re[3]: Strange SQL problem

> Can anybody tell me why the following queries give different results > > Query 1: > select sqs_sessionid, sid > from sysscblst, syssqlstat > where sqs_sessionid = sid;> > This returns 1 row > Query 2: > select sqs_sessionid, sid > from syssqlstat, sysscblst > where sqs_sessionid = sid;> > This return 111 rows > Any ideas=2E They both look the same to me > > > Also, if I add username to the select list for query 2, it also > returns just 1 row --Which version of Informix are you using. It seems to work fine in IDS 7.23UC3. Scratch that last comment. On my test system with no users it works okay. In my production system I see the same behavior. Craig Lanford Mailto:craig.lanford@alltel.com