Hi,

I have a report that is currently linked in the database joins as such:

Table1.x -> Table2.x (left outter join).

I need to modify the report so that it basically links as follows:
Table1.x = Table2.x or Table1.y = table2.y.

However, if I add another link from Table1.y to Table2.y it merely ovewrites the previous link so I only get the records from this new join.

I have tried having no joins between the 2 tables (or changing the join Table1.x = Table2.x to a right-outter join) and then adding the condition {Table1.x = Table2.x} or {Table1.y = table2.y} in the select expert  and it just gives me an error.

Is there another, easier way to do this?

Thanks!

Ah, the error I'm getting when setting the current link to right outter join and putting the join criteria in the selection expert is: cannot retrieve data from the database (database vendor code: -20024). Not sure if it might be related to having too much records in the 2nd table i'm joining to?