Re: Strange SQL problem

Posted in 1998

Glyn_Balmer_at_erith@smtpgwy.supertension.com — Tue, 24 Feb 98 09:04:17 GMT — source: Informix-list mailing list archive (1991-1998)

< Davin Harvey 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 Davin Although I am unfamiliar with the above system tables (we are currently on OnLine 5.01 shortly to move to OnLine 7.xx) I would guess that table sysscblst has 1 row in it and table syssqlstat has 111 rows. It looks to me as though you are not joining to both tables ! Regards Glyn Balmer I.T. Consultant BICC Cables Limited Erith Kent UK Tel: +44 181 225 2281 glynb@bicceri.demon.co.uk