Re: Strange SQL problem

davin_harvey@dsti.co.uk wrote: > 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 Interesting! The same happens for me. The first query returns 1 row with the max sid and the second returns 80 rows. Art S. Kagel