jo@wdl1.UUCP (Jo Mitchell) (04/12/90)
What happens if you try your query with just two tables - badge and timegroup? I'm tending to think theres some type of restriction when using "outer" (there was with Sybases when I used it 6mos ago - something about not allowing it on a table that was used in a nested query). If you figure it out - post it,ok? .............................................................................. Jo Mitchell Of all the things I've lost, I miss my mind the most.
jw@pan.UUCP (Jamie Watson) (04/13/90)
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