Path: utzoo!attcan!uunet!mcsun!cernvax!chx400!pan!jw
From: jw@pan.UUCP (Jamie Watson)
Newsgroups: comp.databases
Subject: Re: Informix, subquery and outer join
Message-ID: <963@pan.UUCP>
Date: 13 Apr 90 06:41:43 GMT
References: <962@pan.UUCP> <3560079@wdl1.UUCP>
Reply-To: jw@pan.UUCP (Jamie Watson)
Organization: Adasoft AG, Solothurn, Switzerland
Lines: 18

In article <3560079@wdl1.UUCP> jo@wdl1.UUCP (Jo Mitchell) writes:
>
> What happens if you try your query with just two tables - badge
> and timegroup?

This is not possible, since the heart of the problem is that there are
three tables invovled, with the outer join and subquery on *different*
tables.  Eliminating the third table reduces the example to a subquery,
which works.

> I'm tending to think theres some type of restriction when using "outer"

Based on a posting from someone at Informix, who said that the examples
I posted produced, when run using the Informix 4.0 release, produced the
results I claimed would be correct, rather than the results I am getting,
this is obviously a bug in the Informix releases I have.

jw