Forum Discussion
Direct Query Report - how to create left join relationship
Hello,
I need to create a report with direct query for two data sources, from different servers. I am trying to create a relationship between the two sources, but it behaves as an inner join and I would need a left join between the tables. Can this be achieved?
Thank you.
4 Replies
Anonymous logically you don't specify the join type in a relationship? What makes you think it is inner join and what you are trying to achieve with outer join? Can you share sample data and expected output.
hello parry2k
I cannot specify the type of join when creating the realtionship, as you can see below. The output of this relationship is only the common title_ids between the two tables.
What I need is all the title_ids from the Query1, even if they have or not a correspondent in the TITLE table. Thank you.
Anonymous it depends on which table you are using for titles, if you use it from query 1, you will see all the titles. As a better design, Title should always have value that is in Query1 but I know sometime these things are not possible.
