Skip to content
Advertisement

SQL Oracle fusion lines with same id

Here is a simplification of my problem:

I would like to have a result like this (keeping those 2 selects):

Not sure how to fusion those 2 lines

One ugly solution is:

Advertisement

Answer

For me it looks like a join with nvl for me:

I’m not sure about your data, so probably it should be just left/right join or even inner join.

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement