RE: Joins on Sysmaster database

Posted in 1999

Russ_Evans@doh.state.fl.us — Tue, 27 Apr 1999 10:07:57 -0400 — source: Informix-list mailing list archive (1991-1998)

If you post your SQL you'll get some good answers. -----Original Message----- From: Shaun Campbell [mailto:shaun@emltd.co.uk] Sent: Tuesday, April 27, 1999 1:17 AM To: informix-list@iiug.org Subject: Joins on Sysmaster database I am trying to write an SQL query on the sysmaster database to identify what sessions there are and how many locks each has. When I join say the syssessions table with syssqlstats via the session id all is fine. When I introduce a third table say syssesprof joining by the session I don't get any records retrieved even though when I query all three tables separately there is equivalent data in all three tables. Joining any two of the three tables retrieves data but not when I introduce a third. Does anyone know why this is or has anyone else come across the problem? BTW I a running IDS 7.30 on Windows NT4. Thanks Shaun Campbell