Cacher is the code snippet organizer for pro developers

SELECT *
FROM BaseTable b
RIGHT JOIN (
  SomeTable s
  INNER JOIN OtherTable o ON o.ID = s.ID
  INNER JOIN MoreTable m ON m.ID = f.ID
) ON b.ID = s.ID