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,