Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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,

Lee

Former Member
Not what you were looking for? View more on this topic or Ask a question