Skip to Content
Former Member
Sep 19, 2008 at 01:49 PM

Outer join over 2 different datasources


Hi I hope someone can help....I have a report (Crystal 2008) where I am combining fields from one Oracle and one Sybase datasource, using a left outer join. This works fine until I add a condition on a column on the right-hand table as it seems to turn the join into an inner-join. So I tried adding an OR IsNull(condition field) to the query, but this makes absolutley no difference - still only getting those records where there exists a record in the right table after the condition is applied.

There MUST be a way to do this...

Thanks in advance,