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 = LEFT JOIN table2 as t2 ON = LEFT JOIN table3 as t3 ON = LEFT JOIN table4 as t4 ON =
13-05-2021 12:01:52 -0400

2 Answers

Hi, Were you able to resolve this issue? I'm running into the same issue.
 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]( 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
You must sign in to add an answer. If you do not have an account, you can register here