Strange SQL problem

This is a multipart message in MIME format --------------InterScan_NT_MIME_Boundary Content-Type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable Hi, =20 Can anybody tell me why the following queries give different results=2E =20 Query 1: select sqs_sessionid, sid from sysscblst, syssqlstat where sqs_sessionid =3D sid; =20 This returns 1 row =20 Query 2: select sqs_sessionid, sid from syssqlstat, sysscblst where sqs_sessionid =3D sid; =20 This return 111 rows =20 Any ideas=2E They both look the same to me=2E =20 Also, if I add username to the select list for query 2, it also=20 returns just 1 row=2E =20 TIA Davin ********************************************************************** DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco=2Eu= k=20 This message and any attachments to it is intended only for the=20 individual or company to which it is addressed and may contain=20 information which is privileged, confidential or prohibited from=20 disclosure or unauthorised use=2E If the recipient of this=20 transmission is not the intended recipient, or the employee or agent=20 responsible for delivering such materials to the intended recipient,=20 you are hereby notified that any use, any form of reproduction,=20 dissemination, copying, disclosure, modification, distribution and/or=20 publication of this e-mail message or its attachments other than by=20 its intended recipient is strictly prohibited by the sender=2E =20 If you have received it in error, please notify us immediately by=20 telephone on the number above and destroy the message and all copies=20 in your possession=2E ********************************************************************** --------------InterScan_NT_MIME_Boundary--