You can translate the question and the replies:

LEFT JOIN losing rows

Hello, I am trying to join some tables, all with LEFT JOIN, but when I try, the numbers of rows in the results is less than the table in FROM statament. The strange thing is that if I change the order of the joins the number of the results rows change. The relationship beetween these tables are always 1: 0/1 and the vql query is like: FROM table0 as t0 LEFT JOIN table1 as t1 ON t1.fk = t0.id LEFT JOIN table2 as t2 ON t2.fk = t0.id LEFT JOIN table3 as t3 ON t3.fk = t0.id LEFT JOIN table4 as t4 ON t4.fk = t3.id
user
13-05-2021 12:01:52 -0400
code

2 Answers

Hi, Were you able to resolve this issue? I'm running into the same issue.
user
 Edited on: 01-09-2021 18:43:52 -0400
Hi, It is a known defect in Denodo Platform and fixed in Denodo update "denodo-v80-update-20210715". You could refer to the section [Installing Updates and Hotfixes](https://community.denodo.com/docs/html/browse/8.0/en/platform/installation/installing_updates_and_hotfixes/installing_updates_and_hotfixes) of Denodo Platform Installation Guide to know about the steps to follow in installing the Denodo update. Hope this helps!
Denodo Team
08-10-2021 06:03:54 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here