I realized how much easier my life would be if SQL had a mode() aggregate function. (I'm using it in the mathematical sense). I'm guessing that either I use SQL in a wierd way or there is a good ...

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 what I have now.