Hello all, I have an issue with using two data source and linking them in the Database expert.
I am doing a left outer join link so I get all the rows from the left table. This works except when I put add a condition on the SELECT EXPERT. I added a date parameter from the Right Table. This seems to be doing an Inner Join even though I set the link as a LEFT OUTER JOIN.
I notice this because if I take out the date parameter, it will return all rows from the LEFT table, but adding the date parameter from my right Table seems to return inner data (or at least it seems like it) where it meets the parameter conditions from the RIGHT table.

Am I being clear here? I apologize in advance if i am not. I can explain in more detail if one wishes.
Has anyone came across this issue? Any work arounds?
thank you so much in advance..