Left Outer Join Tables One to Many

Nextworld Platform
1

I have a left outer join (One to Many) with Primary Table X and Secondary Table Y.

When a record for Y does not exist, there is still a row for X in the join table. Once there is a record for Y is there a way to have 2 rows? One with just X and another with X+Y?

2

No, not that I’m aware of. We only support Left Outer and Inner joins in the platform. So once the record in Table Y exists, only one row that contains the combined contents from both tables will be visible.

3 Likes