ParentFull threadlenzm·Any right join could be written as a left join. What you describe is the use case for a right join - it makes the query more readable.View on HN