left join (select a.id, a.value from tablec INNER JOIN TableD ON C.ID = D.ID AND B.ID IN (1,2,3,4)) C ON A.ID = C.ID Obviously these aren't the real names ann whatnot but the structure is exactly ...