[boxed]

select_related in Django does this. There's also prefetch_related in Django which is not something that is easily done in standard SQL.