I have data that I must extract using the unnest option, but in some cases this data can be null.
The issue is that the result is obtained from 2 vds, and the data of vds1 must be kept.
When using unnest, the record is completely removed, for all cases where the field is null.
Below is the example.
This case is lost when using unnest
Is there another way?