Hi Dmitry,

select PART_NO, NVL(sum( QTY_USED),00000000) as qty_sum from PARTS
left join PARTSUSED on PART_NO.PART_NO = PARTSUSED.PART_NO where (DateFilter)

Use 00000000 like Mask to format the result.

Fabio