select ISNULL(sum(Quantita), 0)-ISNULL(sum(qta_prelevata), 0) AS ct_daprod, max(fam_descr) as famiglia, max(fam_cod) as cod_famiglia from dettagliodocumenti where idtestatadocumenti in ( SELECT idTestataDocumenti FROM TestataDocumenti WHERE (TipoDocumento = 'OCL') AND (NumeroDDT IS NULL) AND (DataDDT IS NULL) AND (CodiceAgente = '999.1') ) group by fam_cod order by famiglia
ACCESSORI