Suppose we join a child table and parent table in Incorta based on a column that is not unique for both child and parent tables. Incorta join by default will pull only one row from parent table even though it has multiple rows satisfying that join condition. But the same functionality is exhibited if there is a join between the tables in Incorta and when the SQL query is ran from dbeaver (3rd party software) with same conditions using left join. And the same SQL query returns multiple rows from parent table when the join in Incorta is removed. Some where the join functionality is enforced when Incorta rewrites the query.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.