You can translate the question and the replies:

Left outer join losing rows

Hi, I'm joining a bunch of derived views. The SQL has 3 INNER joins and 2 LEFT OUTER joins. The LEFT OUTER joins are losing rows. One of this LEFT OUTER join has a static filter condition (like Active = 'Yes'). None of these derived views have PKs defined. Can anyone help me to understand this behaviour and a possible solution? Thanks!
Denodo 8.0 left join
user
02-09-2021 15:50:12 -0400
code

1 Answer

Hi, In this scenario, I would check the [execution trace](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_derived_views/querying_views/execution_trace_of_a_statement#execution-trace-of-a-statement) under the Query Results tab of the view to identify the cause of the behavior. If you still need help and you have a valid support user account, please open a new support case at the [Denodo Support site](https://support.denodo.com/) so that the support team can assist you. Hope this helps!
Denodo Team
03-09-2021 06:54:45 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here