select left(B.B_num,3) as JD,
       sum(B.B_COUNT) as Doc_Cnt,
       P.PROJECTED_VOL as Proj_Vol,
       P.DD_RECD as DD_Recd,
       P.JD_CURRENT as JD_Current,
       P.JD_FUTURE as JD_Future
from   batches B
left   join projectedvolume P
on     P.REPORT_IMPORT_DT = B.REPORT_IMPORT_DT
where  B.REPORT_IMPORT_DT = '2005-10-12'
group by left(b_num,3)