Left join for related tables.