SELECT dt_id, COUNT(dtr_articolo_fk)AS cnt
FROM st_documenti_testate
LEFT OUTER JOIN st_documenti_righe ON dtr_testata_fk = dt_id
WHERE dt_chiuso =0AND cnt = 0
GROUP BY dt_id
SELECT dt_id, COUNT(dtr_articolo_fk)AS cnt
FROM st_documenti_testate
LEFT OUTER JOIN st_documenti_righe ON dtr_testata_fk = dt_id
WHERE dt_chiuso =0AND cnt = 0
GROUP BY dt_id