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!
02-09-2021 15:50:12 -0400

1 Answer

Hi, In this scenario, I would check the [execution trace]( 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]( so that the support team can assist you. Hope this helps!
Denodo Team
03-09-2021 06:54:45 -0400
You must sign in to add an answer. If you do not have an account, you can register here