> 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