Discoverer 3.0 cannot do outer joins

The following is true for Discoverer 3.0.7 for Windows NT, but I suspect it is
true for all versions:

When two folders are created with an outer join (e.g. TableA (+) = TableB)
and a user creates conditions on the joined table (e.g. TableA.col1 = 1),
Discoverer creates a where clause with an outer join to the condition (e.g.
where TableA.col1 (+) = 1). The result of this is you cannot limit the rows
returned by the query with any condition on the joined table. This, in turn,
makes outer joins basically useless in Discoverer 3.0.

Does anyone know a way around this? Received on Tue Oct 14 1997 - 00:00:00 CEST