> I would consider the this second option, but I would change the join:
>
> SELECT ...
> FROM DETAIL
> LEFT JOIN MASTER
>
> Check on your real structure and data if it helps

Hi!

Unfortunately, this is not applicable to my case, as I do have MASTERs
which have no DETAIL (yet).

Josef